Re: PL/pgsql insert into failing even with returning into clause

Thanks. No the error is on the line I am posting about. I realize a record is optimal but it doesn't even work in the simple example. Line ~47-49 is the error depending on which version.

Mark B

> On Apr 16, 2020, at 7:39 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Mark Bannister <mark(at)injection-moldings(dot)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