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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general