Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread 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."

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group