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

From Andreas Kretschmer
Subject Re: Set flag column on update if other columns change?
Date
Msg-id 1124372711.31798.1401207718005.open-xchange@oxweb02.ims-firmen.de
Whole thread Raw
In response to Set flag column on update if other columns change?  (Steve Wampler <swampler@noao.edu>)
Responses Re: Set flag column on update if other columns change?  (Steve Wampler <swampler@noao.edu>)
List pgsql-sql

> 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.



pgsql-sql by date:

Previous
From: Steve Wampler
Date:
Subject: Set flag column on update if other columns change?
Next
From: Steve Wampler
Date:
Subject: Re: Set flag column on update if other columns change?