Re: How does one return rows from plpgsql functions?

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(at)rationalizer(dot)com