Matthew Metnetsky <[EMAIL PROTECTED]> 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 >> need. > > 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. -Doug -- Let us cross over the river, and rest under the shade of the trees. --T. J. Jackson, 1863 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
