Re: Writing SRF

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Writing SRF
Дата
Msg-id 20234.1272474058@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Writing SRF  (Jorge Arevalo <jorgearevalo@gis4free.org>)
Ответы Re: Writing SRF  (Jorge Arevalo <jorgearevalo@gis4free.org>)
Список pgsql-general
Jorge Arevalo <jorgearevalo@gis4free.org> writes:
> I'm writing a SRF following the example from
> http://www.postgresql.org/docs/8.4/interactive/xfunc-c.html (section
> 34.9.10). In the example, in the code executed in first call, we get
> the number of tuples to be returned, and no more. Then, in each call,
> a new tuple is allocated and returned, until reach max_calls.

You don't have to do it that way, by any means.  max_calls is just
a field you can use if you feel like it --- it's not going to be
looked at by anything outside your SRF.  If you don't want to determine
the number of result rows at the start, just ignore max_calls, and
use whatever method is convenient to decide that you're done
returning rows.

            regards, tom lane

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

Предыдущее
От: sunpeng
Дата:
Сообщение: only one namespace allowed by a authid at pg_namespace table?
Следующее
От: John R Pierce
Дата:
Сообщение: Re: How many threads/cores Postgres can utilise?