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