Postgres Pro
Downloads
Home   >   mailing lists

Re: How to avoid UPDATE on same data in table ? - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: How to avoid UPDATE on same data in table ?
Date
Msg-id e290a985-45db-c13e-669c-36e0cd52187a@a-kretschmer.de
Whole thread Raw
In response to How to avoid UPDATE on same data in table ?  (Condor <condor@stz-bg.com>)
Responses Re: How to avoid UPDATE on same data in table ?  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general
Tree view 

Am 02.02.20 um 10:24 schrieb Condor:
> CREATE TRIGGER last_changes
>   BEFORE UPDATE ON status_table
>   FOR EACH ROW
>   WHEN (OLD.* IS DISTINCT FROM NEW.*) 

try to exclude the column lastchange from the comparison.


Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

pgsql-general by date:

Previous
From: Condor
Date:
Subject: How to avoid UPDATE on same data in table ?
Next
From: Andreas Kretschmer
Date:
Subject: Re: How to avoid UPDATE on same data in table ?