Postgres Pro
Downloads
Home   >   mailing lists

Trigger on 0 updated? - Mailing list pgsql-novice

From Alfred Perlstein
Subject Trigger on 0 updated?
Date
Msg-id 20000901110107.N18862@fw.wintelcom.net
Whole thread Raw
List pgsql-novice
Tree view 
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@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

pgsql-novice by date:

Previous
From: ghaverla@freenet.edmonton.ab.ca
Date:
Subject: Re: 7.0.2 regressions testing on Sparc running 2.5.1
Next
From: Tom Lane
Date:
Subject: Re: 7.0.2 regressions testing on Sparc running 2.5.1