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

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to avoid UPDATE on same data in table ?
Date: 2020-02-02 13:37:30
Message-ID: e290a985-45db-c13e-669c-36e0cd52187a@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2020-02-02 14:43:27 Re: How to avoid UPDATE on same data in table ?
Previous Message Condor 2020-02-02 09:24:02 How to avoid UPDATE on same data in table ?