Re: Set-returning function syntax

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Set-returning function syntax
Дата
Msg-id 25161.1021767468@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Set-returning function syntax  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Ответы Re: Set-returning function syntax  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Список pgsql-hackers
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> Does your SRF function allow to return a setof composite data type
> using C function? If so, how can I write such that C function?

The "setof" part is documented in src/backend/utils/fmgr/README.
There's no good documentation for returning tuples at the moment,
but basically you return a pointer to a TupleTableSlot.  (Re-use
the same slot on each call to avoid memory leakage.)  There's an
example in src/backend/executor/functions.c --- look at the uses
of funcSlot.

One reason this isn't documented is that it's really ugly.  It might
be a good idea to change it before we start having lots of user-written
code that depends on it ...
        regards, tom lane


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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Set-returning function syntax
Следующее
От: Joe Conway
Дата:
Сообщение: Re: Set-returning function syntax