Skip site navigation (1) Skip section navigation (2)

Re: Custom Functions

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
Date: 2004-09-28 16:58:05
Message-ID: 87fz52nxeq.fsf@asmodeus.mcnaught.org (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-general
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
>> 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

In response to

pgsql-general by date

Next:From: Shawn ChisholmDate: 2004-09-28 17:35:32
Subject: Re: Foreign key order evaluation
Previous:From: Gaetano MendolaDate: 2004-09-28 16:07:23
Subject: Re: Réf. : Re: R?f. : Re:

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group