Custom Functions

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.

Regards,
Ntinos Katsaros

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.

Thanks though,

~ Matthew

Matthew Metnetsky <met@uberstats.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
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

Hello,

On Tue, 2004-09-28 at 13:57, Tim Penhey wrote:

Matthew Metnetsky wrote:

So, does anyone know of (or have) good examples of queries within
functions (and returning sets of data)?

Thanks in advance,

~ Matthew

Hi Matthew,

I wrote up an example which can be found at
http://www.scorefirst.com/postgresql.html, not sure if it is what you
are after or not.

Tim

That was the exact foundation I was looking for. I'm not sure why I
over looked plpgsql but I did, and its much easier than C custom
functions which are hideous and completely far from portable.

Thanks,

~ Matthew