Christopher Kings-Lynne <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
