| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| 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: |