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

Поиск
Список
Период
Сортировка
От Tobias Gierke
Тема Re: Assignment to composite type variable fails inside function but running query separately yields correct type & value ?
Дата
Msg-id 81bf6542-4a06-9abc-a0d3-a95bc0da2200@code-sourcery.de
обсуждение исходный текст
Ответ на Re: Assignment to composite type variable fails inside function but running query separately yields correct type & value ?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
Thanks for the hint & sorry for the noise, it's working now !

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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Assignment to composite type variable fails inside function but running query separately yields correct type & value ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16837: Invalid memory access on \h in psql