plpgsql RETURN QUERY EXECUTE

Lists: pgsql-patches
From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Subject: plpgsql RETURN QUERY EXECUTE
Date: 2008-04-05 12:03:23
Message-ID: 162867790804050503p5af491d2ga3dc17de7a96c0dd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-patches

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 = $1'
USING b;
RETURN;
END;
$$ LANGUAGE plpgsql;

Regards
Pavel Stehule

Attachment Content-Type Size
return_query_execute.diff text/x-patch 14.8 KB
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
Cc: pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: plpgsql RETURN QUERY EXECUTE
Date: 2008-05-03 00:12:44
Message-ID: 28623.1209773564@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-patches

"Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> 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