Re: returning Setof Record

Поиск
Список
Период
Сортировка
От Avi Schwartz
Тема Re: returning Setof Record
Дата
Msg-id E61AFAFB-DC3F-11D7-AF96-000393AE5044@CFFtechnologies.com
обсуждение исходный текст
Ответ на returning Setof Record  (glenn <vmstech@tpg.com.au>)
Список pgsql-novice
Glenn,

Try this for help.

http://techdocs.postgresql.org/guides/SetReturningFunctions

You will have to specify the structure of the record when you select
from the function.

Avi

On Monday, Sep 1, 2003, at 00:23 America/Chicago, glenn wrote:

> hi
> Q1 - is it at least notionally possible to declare a function to return
> 'setof record' - i.e. a generic composite type as opposed to a
> composite
> type based on an exisiting table?
>
> Q2 - Supposing it is possible When I try the above I get the error:
> "A column definition list is required for functions returning RECORD"
> So now I'm wondering how to define a "column defintition list" ?


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

Предыдущее
От: glenn
Дата:
Сообщение: returning Setof Record
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: ORDER BY question