Re: select into composite type / return

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: select into composite type / return
Дата
Msg-id CAFj8pRBGWLkD=Q6fdp-Sq_2L8f+1etJuA-PfZf=-67hWrJnC2w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: select into composite type / return  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
Ответы Re: select into composite type / return
Список pgsql-sql
Дерево обсуждения


po 22. 3. 2021 v 11:54 odesílatel Gary Stainburn <gary.stainburn@ringways.co.uk> napsal:
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.

probably you can write

D := do_breakdown(...);

and it will be faster

Pavel

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