2010/1/14 Adrian Klaver <adrian.klaver@xxxxxxxxx>: > On Wednesday 13 January 2010 2:17:51 pm Scott Mead wrote: >> On Wed, Jan 13, 2010 at 11:00 PM, Vincenzo Romano < >> >> vincenzo.romano@xxxxxxxxxxx> wrote: >> > It is not the check or the select. >> > It is the way the substitution has been implemented. It looks like the >> > code replaces the variable name and not the value. >> > Which is different from what is written at page 800. >> > I only hope they won't change the manual to match the feature/bug >> > (warning: new joke) >> >> Page 800: >> >> "Another restriction on parameter symbols is that they only work in SELECT, >> INSERT, UPDATE, and DELETE commands. In other statement types (generically >> called utility statements), you must insert values textually even if they >> are just data values." > > Scott, thanks for that I must have read through that section several times at > least with out picking up on it. > > -- > Adrian Klaver > adrian.klaver@xxxxxxxxx > Really? That section is not in any page of the v8.4.2 documentation either PDF or HTML. The sentence has been introduced (yesterday?) in 8.5devel, which is far from being "current". I only hope they won't change the manual to match the feature/bug (warning: new joke) So that was not a joke at all! :-( -- Vincenzo Romano NotOrAnd Information Technologies NON QVIETIS MARIBVS NAVTA PERITVS -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general