Pgsql. Returning field as insert result in function

postgresql

Try this:

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

postgresql

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.

CodeHunter