Postgres Pro
Downloads
Home   >   mailing lists

Re: Update and trigger - Mailing list pgsql-sql

From A. Kretschmer
Subject Re: Update and trigger
Date
Msg-id 20080611083551.GD24984@a-kretschmer.de
Whole thread Raw
In response to Re: Update and trigger  ("Medi Montaseri" <montaseri@gmail.com>)
List pgsql-sql
Tree view 
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.kretschmer@schollglas.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

pgsql-sql by date:

Previous
From: "Medi Montaseri"
Date:
Subject: Re: Update and trigger
Next
From: PostgreSQL Admin
Date:
Subject: Different type of query