[GENERAL] function in pgAdmin

How do I view the result set of a function that returns a refcursor in pgAdmin? I am trying to test it in pgadmin my calling it like this, but I can't see the result set, it only says: Query result with 1 rows discarded. Query result with 328 rows discarded. Query returned successfully with no r

Re: [GENERAL] Dynamic SQL in Function

Is this possible without having to pass in the _ref parameter? Thanks Ryan > On Wed, Apr 22, 2009 at 12:29 PM, wrote: >> If I have built a dynamic sql statement in a function, how do i return >> it >> as a ref cursor? > > CREATE FUNCTION reffunc(_ref) RETURNS refcursor AS > $$ > BEGIN > OP

[GENERAL] Dynamic SQL in Function

If I have built a dynamic sql statement in a function, how do i return it as a ref cursor? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general