2009/11/13 Tom Lane <t...@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 > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
