Re: select into composite type / return

Поиск
Список
Период
Сортировка
От Gary Stainburn
Тема Re: select into composite type / return
Дата
Msg-id 5f54e16c-63b4-f1b4-91ff-1ccefd271139@ringways.co.uk
обсуждение исходный текст
Ответ на Re: select into composite type / return  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: select into composite type / return  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-sql
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.

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: select into composite type / return
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: select into composite type / return