Re: How to avoid UPDATE on same data in table ?

[Andreas Kretschmer]

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