Pgsql. Returning field as insert result in function

postgresql

Solution

Try this:

INSERT INTO table(id,field)
VALUES($id,$value)
RETURNING id into var;

Problem

I can return id as an `INSERT` result, like ``` INSERT INTO table(id,field) VALUES($id,$value) RETURNING id; ``` But i cannot return it and assign to variable into my function ``` var = INSERT INTO table(id,field) VALUES($id,$value) RETURNING id; ``` or ``` SELECT INTO var INSERT INTO table(id,field) VALUES($id,$value) RETURNING id; ``` don't work. How can i do it?

Original source