Re: ON UPDATE trigger question

On Wed, Sep 12, 2007 at 01:56:13PM -0500, Josh Trutwin wrote:
> Or would you have to compare each field in OLD, NEW to see if
> anything actually changed?

you dont have to compare all columns (at least not in 8.2 and newer).
please take a look at
http://www.depesz.com/index.php/2007/09/08/avoiding-empty-updates/
make sure you'll also read comment from david fetter.

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)