Re: Triggers and Function. - Mailing list pgsql-novice

From Bruce Hyatt
Subject Re: Triggers and Function.
Date
Msg-id 248676.40606.qm@web34401.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Triggers and Function.  (Decibel! <decibel@decibel.org>)
List pgsql-novice
--- On Wed, 8/27/08, Decibel! <decibel@decibel.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




pgsql-novice by date:

Previous
From: Decibel!
Date:
Subject: Re: Triggers and Function.
Next
From: richard terry
Date:
Subject: How to save a image file in a postgres data field.