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

Browse pgsql-php by date

  From Date Subject
Next Message Marc McIntyre 2006-10-19 11:37:06 Re: plpgsql returning array
Previous Message Jean-Christophe Roux 2006-10-17 02:02:33 Re: plpgsql returning array