Re: [HACKERS] minimal update trigger

2008-02-20 Thread Andrew Dunstan
David Fetter wrote: On Tue, Feb 19, 2008 at 09:32:30PM -0500, Andrew Dunstan wrote: As discussed a little while back, I would like to add a generic trigger function which will force an update to skip if the new and old tuples are identical. This one has lots of use cases. Did the ea

Re: [HACKERS] minimal update trigger

2008-02-20 Thread David Fetter
On Tue, Feb 19, 2008 at 09:32:30PM -0500, Andrew Dunstan wrote: > > As discussed a little while back, I would like to add a generic > trigger function which will force an update to skip if the new and > old tuples are identical. This one has lots of use cases. Did the earlier discussion settle on

[HACKERS] minimal update trigger

2008-02-19 Thread Andrew Dunstan
As discussed a little while back, I would like to add a generic trigger function which will force an update to skip if the new and old tuples are identical. The guts of this is the following snippet of code: |rettuple = newtuple = trigdata->tg_newtuple; oldtuple = trigdata->t