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: 20061018224453.GF56874@nasby.net (view raw or flat)
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      http://enterprisedb.com      512.569.9461 (cell)

In response to

Responses

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-2014 The PostgreSQL Global Development Group