Re: [Fwd: plpgsql and booleans?] - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: [Fwd: plpgsql and booleans?]
Date
Msg-id 400DD746.6070906@familyhealth.com.au
Whole thread Raw
In response to Re: [Fwd: plpgsql and booleans?]  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>>EXECUTE ''UPDATE test_table SET test_col '' || 
>>quote_literal(NEW.test_col2) || '';'';
> 
> 
> Seems it'd be easier without EXECUTE:
> 
>     UPDATE test_table SET test_col = NEW.test_col2;

Actually, yes you're right - we don't need EXECUTE in our case. 
However, it still doesn't answer the question of how you use 
quote_literal on a boolean value?

Chris



pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Old binary packages.
Next
From: Tatsuo Ishii
Date:
Subject: Re: Encoding problems in PostgreSQL with XML data