Trigger on 0 updated?

From: Alfred Perlstein <bright(at)wintelcom(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Trigger on 0 updated?
Date: 2000-09-01 18:01:07
Message-ID: 20000901110107.N18862@fw.wintelcom.net
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-novice

Is there a way to make a trigger that only fires after an UPDATE
that doesn't affect any rows?

Is there a way to pass the number of updated rows to a trigger?

Is it possible to see that 0 rows were updated in an AFTER trigger?

thanks,
--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2000-09-01 21:29:15 Re: 7.0.2 regressions testing on Sparc running 2.5.1
Previous Message ghaverla 2000-09-01 16:34:17 Re: 7.0.2 regressions testing on Sparc running 2.5.1