|From:||Doug McNaught <doug(at)mcnaught(dot)org>|
|To:||Matthew Metnetsky <met(at)uberstats(dot)com>|
|Cc:||Katsaros Kwn/nos <ntinos(at)aueb(dot)gr>, Pgsql General <pgsql-general(at)postgresql(dot)org>|
|Subject:||Re: Custom Functions|
|Views:||Raw Message | Whole Thread | Download mbox|
Matthew Metnetsky <met(at)uberstats(dot)com> writes:
> On Tue, 2004-09-28 at 10:55, Katsaros Kwn/nos wrote:
>> > So, does anyone know of (or have) good examples of queries within
>> > functions (and returning sets of data)?
>> I'm not very experienced in PostgreSQL but maybe SPI functions is what you
> Yeah I took a look at them, but I'm not sold because when I look at
> Postgres' build in functions I never see it. Its as if SPI_* is slower
> or something.
SPI is an internal API for server-side functions to use. Client apps
will never use it.
I think Katsaros might have meant "set-returning functions" (SRF)
which are documented in the manual and available to client apps.
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863
|Next Message||Shawn Chisholm||2004-09-28 17:35:32||Re: Foreign key order evaluation|
|Previous Message||Gaetano Mendola||2004-09-28 16:07:23||Re: Réf. : Re: R?f. : Re:|