Thread: [pgAdmin III] #159: Reverse engineering of a function that RETURNS TABLE
#159: Reverse engineering of a function that RETURNS TABLE ----------------------+----------------------------------------------------- Reporter: brsa | Owner: dpage Type: bug | Status: new Priority: minor | Milestone: Component: pgadmin | Version: 1.10 Keywords: SQL pane | Platform: all ----------------------+----------------------------------------------------- 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; -- Ticket URL: <http://code.pgadmin.org/trac/ticket/159> pgAdmin III <http://code.pgadmin.org/trac/> pgAdmin III
Re: [pgAdmin III] #159: Reverse engineering of a function that RETURNS TABLE
From
"pgAdmin Trac"
Date:
#159: Reverse engineering of a function that RETURNS TABLE ----------------------+----------------------------------------------------- Reporter: brsa | Owner: gleu Type: bug | Status: assigned Priority: minor | Milestone: Component: pgadmin | Version: 1.10 Keywords: SQL pane | Platform: all ----------------------+----------------------------------------------------- Changes (by gleu): * owner: dpage => gleu * status: new => assigned -- Ticket URL: <http://code.pgadmin.org/trac/ticket/159#comment:1> pgAdmin III <http://code.pgadmin.org/trac/> pgAdmin III
Re: [pgAdmin III] #159: Reverse engineering of a function that RETURNS TABLE
From
"pgAdmin Trac"
Date:
#159: Reverse engineering of a function that RETURNS TABLE ----------------------+----------------------------------------------------- Reporter: brsa | Owner: gleu Type: bug | Status: closed Priority: minor | Milestone: 1.10.3 Component: pgadmin | Version: 1.10 Resolution: fixed | Keywords: SQL pane Platform: all | ----------------------+----------------------------------------------------- Changes (by gleu): * status: assigned => closed * resolution: => fixed * milestone: => 1.10.3 Comment: Fixed in r8248 and r8249. -- Ticket URL: <http://code.pgadmin.org/trac/ticket/159#comment:2> pgAdmin III <http://code.pgadmin.org/trac/> pgAdmin III