"Raphael Bauduin" <[EMAIL PROTECTED]> writes:
> --> ERROR: function quote_literal(boolean) does not exist
Oh, you must be using some version that didn't have a bool->text cast.
I'd suggest making one. Or just make a quote_literal(boolean)
function.
regards, tom lane
--
On Thu, Sep 18, 2008 at 2:35 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Raphael Bauduin" <[EMAIL PROTECTED]> writes:
>> EXECUTE 'UPDATE tbl SET '
>> || quote_ident(colname)
>> || ' = '
>> || quote_literal(newvalue)
>> || ' WHERE key = '
>> || quote_literal(ke
"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
