Postgres Pro
Downloads
Home   >   mailing lists

Re: plpgsql returning array - Mailing list pgsql-php

From Jim C. Nasby
Subject Re: plpgsql returning array
Date
Msg-id 20061018224453.GF56874@nasby.net
Whole thread Raw
In response to Re: plpgsql returning array  (Marc McIntyre <mmcintyre@squiz.net>)
Responses Re: plpgsql returning array  (Marc McIntyre <mmcintyre@squiz.net>)
List pgsql-php
Tree view 
On Sun, Oct 15, 2006 at 04:11:30PM +1000, Marc McIntyre wrote:
> You should use a set returning function. Your function can be rewritten
> as a set returning function like so:

Isn't there a way to return an array? SRFs are great, but not always the
best tool.

BTW, neither function should be marked as VOLATILE... they're actually
IMMUTABLE as written.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

pgsql-php by date:

Previous
From: Jean-Christophe Roux
Date:
Subject: Re: plpgsql returning array
Next
From: Marc McIntyre
Date:
Subject: Re: plpgsql returning array