Обсуждение: [Fwd: plpgsql and booleans?]
Hi guys, When writing a PL/pgSQL trigger function how do you handle the case : EXECUTE ''UPDATE test_table SET test_col '' || quote_literal(NEW.test_col2) || '';''; where test_col and test_col2 are boolean fields? The case above gives : ERROR: function quote_literal(boolean) does not exist And without the quote_literal() gives : ERROR: operator does not exist: text || boolean Is there supposed to be a quote_literal() for booleans? Chris
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes: > When writing a PL/pgSQL trigger function how do you handle the case : > 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; regards, tom lane
>>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