Re: select into composite type / return

From: Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: select into composite type / return
Date: 2021-03-22 10:54:21
Message-ID: 5f54e16c-63b4-f1b4-91ff-1ccefd271139@ringways.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 22/03/2021 10:40, Pavel Stehule wrote:
> select into D do_breakdown(v.v1,v.v2,v.v3,v.v4,v.v5,v.v6,v.v7);
>
> this line is wrong
>
> you should to use select * from do_breakdown(..) into D
>
> note - plpgsql is case insensitive language - all identifiers are
> transformed to lower case form - so using identifiers like D is not a
> good idea.
>
> Regards
>
> Pavel
Hi Pavel,

Thank you for this. As soon as I read your answer, it was obvious. It
matches the same issue I had last week.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2021-03-22 10:56:30 Re: select into composite type / return
Previous Message Pavel Stehule 2021-03-22 10:40:08 Re: select into composite type / return