Pgsql. Returning field as insert result in function

Question

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?

Answer 1

Try this:

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

Answer 2

You could also use:

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

Readability is of course a personal preference, but I like this syntax because it shows an obvious assignment.