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
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
