Postgres Pro
Downloads
Home   >   mailing lists

Re: How does one return rows from plpgsql functions? - Mailing list pgsql-general

From Holger Krug
Subject Re: How does one return rows from plpgsql functions?
Date
Msg-id 20020122083023.A19724@dev12.rationalizer.com
Whole thread Raw
In response to Re: How does one return rows from plpgsql functions?  (Holger Krug <hkrug@rationalizer.com>)
List pgsql-general
Tree view 
On Mon, Jan 21, 2002 at 07:16:24PM +0100, Holger Krug wrote:
> SELECT get_id(p), get_fielda(p) WHERE p = update_get(1);

Sorry this was wrong. Obviously it should be:

 SELECT get_id(t.p), get_fielda(t.p) FROM (SELECT update_get(1) as p) as t;

resp.:

 SELECT get_id(p), get_fielda(p) FROM (SELECT update_get(1) as p) as NN;

--
Holger Krug
hkrug@rationalizer.com

pgsql-general by date:

Previous
From: Einar Karttunen
Date:
Subject: Re: frustration with database size
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL Licence: GNU/GPL