Reverse engineering of a function that RETURNS TABLE

[brsa]

The feature is new in pg 8.4 and a search in trac shows that Ashesh added the functionality in changeset 7815 on April, 17th 2009.

However, the display in the SQL pane of pgAdmin 1.10.2 is wrong. It says "RETURNS SETOF record"; OUT parameters are lost.

Demo:

-- I say --

CREATE OR REPLACE FUNCTION f_test()

RETURNS TABLE (x integer, y text) AS

$BODY$
BEGIN

x := 1; y := 'test'; RETURN NEXT;

RETURN QUERY SELECT '2'::int4, 'test2'::text;

END;
$BODY$

LANGUAGE 'plpgsql' VOLATILE

-- pgAmin say --

CREATE OR REPLACE FUNCTION f_test()

RETURNS SETOF record AS

$BODY$
BEGIN

x := 1; y := 'test';
RETURN NEXT;

RETURN QUERY
SELECT 2::int4, 'test2'::text;

END;
$BODY$

LANGUAGE 'plpgsql' VOLATILE
COST 100
ROWS 1000;

ALTER FUNCTION f_test() OWNER TO postgres;

[gleu]

Fixed in r8248 and r8249.