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

Re: Update and trigger

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Update and trigger
Date: 2008-06-11 08:35:51
Message-ID: 20080611083551.GD24984@a-kretschmer.de (view raw or flat)
Thread:
Lists: pgsql-sql
am  Wed, dem 11.06.2008, um  0:54:55 -0700 mailte Medi Montaseri folgendes:
> Thanks...but a difference seems to be that the rule is not specific to update
> on a particular col but any col of a row getting updated...
> 
> Thanks

Okay, but i havn't an idea. A statement level trigger can't see the the
data in NEW and OLD. And a row level trigger fires for every row.


> 
> On Tue, Jun 10, 2008 at 10:21 PM, A. Kretschmer <
> andreas(dot)kretschmer(at)schollglas(dot)com> wrote:

Please, no silly top posting with fullquote below, i'm reading from top
to bottom.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

In response to

pgsql-sql by date

Next:From: PostgreSQL AdminDate: 2008-06-11 17:27:45
Subject: Different type of query
Previous:From: Medi MontaseriDate: 2008-06-11 07:54:55
Subject: Re: Update and trigger

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