Missing feature in plpgsql EXECUTE ... USING support

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Missing feature in plpgsql EXECUTE ... USING support
Date: 2009-11-13 18:58:25
Message-ID: 6345.1258138705@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2009-11-13 19:01:32 Re: Aggregate ORDER BY patch
Previous Message Alvaro Herrera 2009-11-13 18:32:47 Re: Experimental patch: generating BKI revisited