Re: Assignment to composite type variable fails inside function but running query separately yields correct type & value ?

On Tue, Jan 26, 2021 at 5:56 AM Tobias Gierke <tobias.gierke@code-sourcery.de> wrote:

voip$#         SELECT (t1.a_major, t1.a_minor )::version_num INTO _myid

Bug or feature ?

Feature.  The first column of the select result gets placed into the first field of _myid, the second column of the select result gets placed into the second field of _myid.  This is how assignment to row-typed variables (and record-typed too) works in pl/pgsql.

David J.