avoid the creating the type for setof

Поиск
Список
Период
Сортировка
От John Fabiani
Тема avoid the creating the type for setof
Дата
Msg-id 1762087.ynHxkPSFx3@linux-12
обсуждение исходный текст
Ответы Re: avoid the creating the type for setof  (Thomas Kellerer <spam_eater@gmx.net>)
Re: avoid the creating the type for setof  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: avoid the creating the type for setof  (John Fabiani <johnf@jfcomputer.com>)
Список pgsql-sql
Hi,
I recall somewhere I saw a simple plpgsql function that returned a table with 
more than one record that did not use a defined type or a temp table ( at 
least I think I did).  Is it possible to create such a function that will 
return more than one record and not require a record type or temp table?

something like

return setof record as
return query select ...

return


Johnf


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

Предыдущее
От: Leif Biberg Kristensen
Дата:
Сообщение: Re: Current transaction is aborted, commands ignored until end of transaction block
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: avoid the creating the type for setof