Re: select into composite type / return

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.