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 M

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: > > http://momjian.post

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. --- Pa

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 SQ

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 sql

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

[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 broadcas