2007/10/17, Brendan Jurd <[EMAIL PROTECTED]>: > On 10/17/07, Pavel Stehule <[EMAIL PROTECTED]> wrote: > > New syntax: > > > > a) EXECUTE stringexpr > > [INTO [STRICT] varlist > > [USING exprlist] > > > > b) FOR varlist IN EXECUTE stringexpr USING exprlist LOOP .... > > Just chiming in with a +1. I would find this feature very useful. > Substitution of parameters is way more elegant than quoting, and the > syntax looks nice. >
I am doing some simple speed tests, and with USING run dynamic queries little bit faster (15%). Prepared statement accepts params in binary form, so we don't need call out functions. Pavel ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly