Re: [Fwd: plpgsql and booleans?]
От
Christopher Kings-Lynne
Тема
Re: [Fwd: plpgsql and booleans?]
Дата
Msg-id
400DD746.6070906@familyhealth.com.au
Ответ на
Re: [Fwd: plpgsql and booleans?] (Tom Lane)
Список
Дерево обсуждения
[Fwd: plpgsql and booleans?] Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: [Fwd: plpgsql and booleans?] Tom Lane <tgl@sss.pgh.pa.us>
Re: [Fwd: plpgsql and booleans?] Christopher Kings-Lynne <chriskl@familyhealth.com.au>
>>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 по дате отправления
