Skip site navigation (1) Skip section navigation (2)

Re: How to notice column changes in trigger

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Andreas Pflug <Andreas(dot)Pflug(at)web(dot)de>,pgsql-performance(at)postgresql(dot)org
Subject: Re: How to notice column changes in trigger
Date: 2003-03-06 17:05:37
Message-ID: 200303060905.37760.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Andreas,

> This doesn't cover case 3, since UPDATE ... SET b=b will lead to
> NEW.b=OLD.b

Why do you care about SET b = b?

And shouldn't this discussion be on the PGSQL-SQL list?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

pgsql-performance by date

Next:From: Matt MelloDate: 2003-03-06 18:51:11
Subject: ISNULL performance tweaks
Previous:From: Andreas PflugDate: 2003-03-06 16:09:40
Subject: Re: How to notice column changes in trigger

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group