Missing feature in plpgsql EXECUTE ... USING support

Started by Tom Laneover 16 years ago2 messageshackers
Jump to latest
#1Tom 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?

regards, tom lane

#2Pavel Stehule
pavel.stehule@gmail.com
In reply to: Tom Lane (#1)
Re: Missing feature in plpgsql EXECUTE ... USING support

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

Show quoted text

                       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