Re: select into composite type / return

po 22. 3. 2021 v 11:54 odesílatel Gary Stainburn <
gary(dot)stainburn(at)ringways(dot)co(dot)uk> napsal:

> 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.
>

probably you can write

D := do_breakdown(...);

and it will be faster

Pavel