Re: [GENERAL] table column vs. out param [1:0] - Mailing list pgsql-sql

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