Re: Triggers and Function.

From: Bruce Hyatt <brucejhyatt(at)yahoo(dot)com>
To: Stephen Greensmith <s(dot)greensmith(at)ncrl(dot)co(dot)uk>, pgsql-novice(at)postgresql(dot)org, Decibel! <decibel(at)decibel(dot)org>
Subject: Re: Triggers and Function.
Date: 2008-08-27 20:37:17
Message-ID: 248676.40606.qm@web34401.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

--- On Wed, 8/27/08, Decibel! <decibel(at)decibel(dot)org> wrote:

> > Why because I need to know if the application is
> setting a value in a
> > column or not. A bit like having a default on an
> update as well as an
> > insert.
>
> Ok, but why do you need to know if the field appears in the
> UPDATE, even
> if it's value doesn't change?
>

Can't the changes be inserted into an audit table as well as updated in the target table?

Bruce

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message richard terry 2008-08-28 21:26:06 How to save a image file in a postgres data field.
Previous Message Decibel! 2008-08-27 16:34:24 Re: Triggers and Function.