Re: Missing feature in plpgsql EXECUTE ... USING support - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Missing feature in plpgsql EXECUTE ... USING support
Date
Msg-id 162867790911131230j7fc8ade7s7f124fe732e7c606@mail.gmail.com
Whole thread Raw
In response to Missing feature in plpgsql EXECUTE ... USING support  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
2009/11/13 Tom Lane <tgl@sss.pgh.pa.us>:
> I just noticed that plpgsql's OPEN cursor FOR EXECUTE command lacks
> a USING clause, so the only way to put parameters into the string is
> textual insertion.  Seems like an oversight, since every other variant
> of EXECUTE in plpgsql can do USING.  Did we omit that intentionally?
>

It's my mistake. I am sure, so OPEN FOR EXECUTE needs USING clause.
It's a paradox so Oracle OPEN function missing any support for dynamic
query. We are better than Oracle :).

Pavel


>                        regards, tom lane
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Hot standby, overflowed snapshots, testing
Next
From: Grzegorz Jaskiewicz
Date:
Subject: Re: cvs head doesn't pass make check on one of the machines here