Re: [PATCHES] plpgsql RETURN QUERY EXECUTE

2008-05-02 Thread Tom Lane
"Pavel Stehule" <[EMAIL PROTECTED]> writes: > This patch allows dynamic queries in RETURN QUERY statement. > http://archives.postgresql.org/pgsql-hackers/2008-02/msg01180.php Applied, thanks. regards, tom lane -- Sent via pgsql-patches mailing list (pgsql-patches@postgre

[PATCHES] plpgsql RETURN QUERY EXECUTE

2008-04-05 Thread Pavel Stehule
Hello This patch allows dynamic queries in RETURN QUERY statement. http://archives.postgresql.org/pgsql-hackers/2008-02/msg01180.php Sample: CREATE OR REPLACE FUNCTION test(tab varchar, b integer) RETURNS SETOF integer AS $$ BEGIN RETURN QUERY EXECUTE 'SELECT a FROM ' || tab 'WHERE b = $