Mark Bannister <mark@injection-moldings.com> writes:
> I have a simple insert into query in a PL/pgsql function. I have a
> returning into clause.
> I have tried it multiple ways but it always gives me the "query has no
> destination for result data" error.
It looks like you forgot to include "INTO plpgsql-result-variable"
in the last UPDATE RETURNING in the function. You do have that
in the earlier one, maybe you just got confused about which one
the system was complaining about?
> *Desired version:*
> INSERT INTO __formuilist (formidfkey,uiname,mastertablelistxref_fkey)
> VALUES(_formidfkey,_uiname, _mastertablelistxref_fkey)
> RETURNING ROW
> INTO formlistrow ;
I believe the easiest way to accomplish that is something like
INSERT ... RETURNING __formuilist.* INTO composite_variable
where composite_variable could be declared RECORD, or given
the table's named rowtype.
regards, tom lane