"Raphael Bauduin" <[EMAIL PROTECTED]> writes:
> EXECUTE 'UPDATE tbl SET '
> || quote_ident(colname)
> || ' = '
> || quote_literal(newvalue)
> || ' WHERE key = '
> || quote_literal(keyvalue);
> It works fine, except when I want to include a boolean value: the cast
> of newvalue from boolean to text causes problem.
What problem? 'true' and 'false' are accepted as input for boolean
AFAICS.
regards, tom lane
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
