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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Assignment to composite type variable fails inside function but running query separately yields correct type & value ?
Дата
Msg-id CAKFQuwapumtrdWSWZXNGoLxqC8eeseeZx1H-EgB3C3Qor+y_-g@mail.gmail.com
обсуждение исходный текст
Ответ на Assignment to composite type variable fails inside function but running query separately yields correct type & value ?  (Tobias Gierke <tobias.gierke@code-sourcery.de>)
Ответы Re: Assignment to composite type variable fails inside function but running query separately yields correct type & value ?  (Tobias Gierke <tobias.gierke@code-sourcery.de>)
Список pgsql-bugs
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Tobias Gierke
Дата:
Сообщение: 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 ?