Re: [Fwd: plpgsql and booleans?]

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [Fwd: plpgsql and booleans?]
Date: 2004-01-21 01:35:02
Message-ID: 400DD746.6070906@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2004-01-21 04:51:52 Re: Encoding problems in PostgreSQL with XML data
Previous Message Christopher Kings-Lynne 2004-01-21 00:21:57 Re: Old binary packages.