Re: [HACKERS] Missing feature in plpgsql EXECUTE ... USING support

2009-11-13 Thread Pavel Stehule
2009/11/13 Tom Lane : > 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 intenti

[HACKERS] Missing feature in plpgsql EXECUTE ... USING support

2009-11-13 Thread Tom Lane
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?