Thread: proposal: plpgsql return execute ...
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
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
On Wed, Feb 27, 2008 at 1:58 PM, Neil Conway <neilc@samurai.com> 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 [USING]; > > What is the USING clause for? parameter binding. see: http://archives.postgresql.org/pgsql-patches/2006-08/msg00267.php merlin
On 27/02/2008, Merlin Moncure <mmoncure@gmail.com> wrote: > On Wed, Feb 27, 2008 at 1:58 PM, Neil Conway <neilc@samurai.com> 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 [USING]; > > > > What is the USING clause for? > > > parameter binding. > > see: http://archives.postgresql.org/pgsql-patches/2006-08/msg00267.php > > > merlin > I sent modernized version http://archives.postgresql.org/pgsql-patches/2007-10/msg00161.php Pavel
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. --------------------------------------------------------------------------- Pavel Stehule wrote: > On 27/02/2008, Merlin Moncure <mmoncure@gmail.com> wrote: > > On Wed, Feb 27, 2008 at 1:58 PM, Neil Conway <neilc@samurai.com> 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 [USING]; > > > > > > What is the USING clause for? > > > > > > parameter binding. > > > > see: http://archives.postgresql.org/pgsql-patches/2006-08/msg00267.php > > > > > > merlin > > > > I sent modernized version > http://archives.postgresql.org/pgsql-patches/2007-10/msg00161.php > > Pavel > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
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 <bruce@momjian.us> wrote: > > 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. > > --------------------------------------------------------------------------- > > > > Pavel Stehule wrote: > > On 27/02/2008, Merlin Moncure <mmoncure@gmail.com> wrote: > > > On Wed, Feb 27, 2008 at 1:58 PM, Neil Conway <neilc@samurai.com> 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 [USING]; > > > > > > > > What is the USING clause for? > > > > > > > > > parameter binding. > > > > > > see: http://archives.postgresql.org/pgsql-patches/2006-08/msg00267.php > > > > > > > > > merlin > > > > > > > I sent modernized version > > http://archives.postgresql.org/pgsql-patches/2007-10/msg00161.php > > > > Pavel > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 7: You can help support the PostgreSQL project by donating at > > > > http://www.postgresql.org/about/donate > > > -- > Bruce Momjian <bruce@momjian.us> http://momjian.us > EnterpriseDB http://postgres.enterprisedb.com > > + If your life is a hard drive, Christ can be your backup. + >
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 <bruce@momjian.us> wrote: > > > > 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. > > > > --------------------------------------------------------------------------- > > > > > > > > Pavel Stehule wrote: > > > On 27/02/2008, Merlin Moncure <mmoncure@gmail.com> wrote: > > > > On Wed, Feb 27, 2008 at 1:58 PM, Neil Conway <neilc@samurai.com> 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 [USING]; > > > > > > > > > > What is the USING clause for? > > > > > > > > > > > > parameter binding. > > > > > > > > see: http://archives.postgresql.org/pgsql-patches/2006-08/msg00267.php > > > > > > > > > > > > merlin > > > > > > > > > > I sent modernized version > > > http://archives.postgresql.org/pgsql-patches/2007-10/msg00161.php > > > > > > Pavel > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 7: You can help support the PostgreSQL project by donating at > > > > > > http://www.postgresql.org/about/donate > > > > > > -- > > Bruce Momjian <bruce@momjian.us> http://momjian.us > > EnterpriseDB http://postgres.enterprisedb.com > > > > + If your life is a hard drive, Christ can be your backup. + > > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your Subscription: > http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-hackers -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +