Re: Set flag column on update if other columns change? - Mailing list pgsql-sql

On 05/27/2014 09:21 AM, Andreas Kretschmer wrote:
>> Steve Wampler <swampler@noao.edu> hat am 27. Mai 2014 um 18:00 geschrieben:
>> I've got a table where updates that actually change things need to
>> record in the row that the row has been modified.  I'm assuming that a
>> trigger function (OK to be plpgsql, performance isn't much of
>> an issue) is the best way to do this, but haven't done much
>> with trigger functions.  Can someone give me some pointers
>> on how this might be accomplished?  I have to check for
>> changes in a subset of the columns (e.g. ignore timestamps, etc.).
>
> Trigger BEFORE, compare NEW. with OLD.. Easy.

Thanks!  I didn't know about OLD...


-- 
Steve Wampler -- swampler@noao.edu
The gods that smiled on your birth are now laughing out loud.