Re: [Fwd: plpgsql and booleans?]

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [Fwd: plpgsql and booleans?]
Date: 2004-01-20 16:28:46
Message-ID: 24480.1074616126@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-01-20 16:36:26 Re: PostGIS dropgeometrycolumn function (Was: Re: [7.4] "permissions problem" with pl/pgsql function )
Previous Message Tom Lane 2004-01-20 16:26:02 Re: Recursive optimization of IN subqueries