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

Re: plpgsql returning array

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: Marc McIntyre <mmcintyre(at)squiz(dot)net>
Cc: Jean-Christophe Roux <jcxxr(at)yahoo(dot)com>, pgsql-php(at)postgresql(dot)org
Subject: Re: plpgsql returning array
Date: 2006-10-18 22:44:53
Message-ID: (view raw or whole thread)
Lists: pgsql-php
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(at)nasby(dot)net
EnterpriseDB      512.569.9461 (cell)

In response to


pgsql-php by date

Next:From: Marc McIntyreDate: 2006-10-19 11:37:06
Subject: Re: plpgsql returning array
Previous:From: Jean-Christophe RouxDate: 2006-10-17 02:02:33
Subject: Re: plpgsql returning array

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