Re: [HACKERS] proposal: plpgsql return execute ...

2008-03-03 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. ---

Re: [HACKERS] proposal: plpgsql return execute ...

2008-03-03 Thread Pavel Stehule
Hello I have to write this patch first. I am waiting for apply EXECUTE USING patch and others plpgsql patches. Regards Pavel Stehule On 03/03/2008, Bruce Momjian [EMAIL PROTECTED] wrote: Your patch has been added to the PostgreSQL unapplied patches list at:

Re: [HACKERS] proposal: plpgsql return execute ...

2008-03-03 Thread Bruce Momjian
Pavel Stehule wrote: Hello I have to write this patch first. I am waiting for apply EXECUTE USING patch and others plpgsql patches. OK, removed. Thanks. --- Regards Pavel Stehule On 03/03/2008, Bruce Momjian

[HACKERS] proposal: plpgsql return execute ...

2008-02-27 Thread Pavel Stehule
Hello I thing RETURN QUERY is successful idea. It should be completed with support of dynamic SQL. Syntax: RETURN EXECUTE sqlstring [USING]; This is shortcut for FOR r IN EXECUTE sqlstring USING LOOP RETURN NEXT r; END LOOP; Regards Pavel Stehule ---(end of

Re: [HACKERS] proposal: plpgsql return execute ...

2008-02-27 Thread Neil Conway
On Wed, 2008-02-27 at 15:24 +0100, Pavel Stehule wrote: I thing RETURN QUERY is successful idea. It should be completed with support of dynamic SQL. Yeah, I can see that being useful. RETURN EXECUTE sqlstring [USING]; What is the USING clause for? -Neil ---(end

Re: [HACKERS] proposal: plpgsql return execute ...

2008-02-27 Thread Merlin Moncure
On Wed, Feb 27, 2008 at 1:58 PM, Neil Conway [EMAIL PROTECTED] wrote: On Wed, 2008-02-27 at 15:24 +0100, Pavel Stehule wrote: I thing RETURN QUERY is successful idea. It should be completed with support of dynamic SQL. Yeah, I can see that being useful. RETURN EXECUTE sqlstring

Re: [HACKERS] proposal: plpgsql return execute ...

2008-02-27 Thread Pavel Stehule
On 27/02/2008, Merlin Moncure [EMAIL PROTECTED] wrote: On Wed, Feb 27, 2008 at 1:58 PM, Neil Conway [EMAIL PROTECTED] wrote: On Wed, 2008-02-27 at 15:24 +0100, Pavel Stehule wrote: I thing RETURN QUERY is successful idea. It should be completed with support of dynamic SQL.