On 23.08.2007, at 11:55, Albe Laurenz wrote:
CREATE FUNCTION b(status OUT integer, status_text OUT text)
LANGUAGE plpgsql STABLE STRICT AS
$$DECLARE
RENAME status TO out_status;
RENAME status_text TO out_status_text;
BEGIN
SELECT status, status_text
FROM a()
INTO out_status, out_status_text;
RETURN;
END;$$;
See
http://www.postgresql.org/docs/current/static/plpgsql-
declarations.html#
PLPGSQL-DECLARATION-RENAMING-VARS
Yours,
Laurenz Albe
From http://www.postgresql.org/docs/current/static/plpgsql-
declarations.html#PLPGSQL-DECLARATION-RENAMING-VARS
Note: RENAME appears to be broken as of PostgreSQL 7.3. Fixing this
is of low priority, since ALIAS covers most of the practical uses of
RENAME.
Seems to work though. Could somebody please confirm/reject that this
has been fixed?
Kristo Kaiv
http://kaiv.wordpress.com (PostgreSQL blog)
