Postgres Pro
Downloads
Home   >   mailing lists

Re: change a field - Mailing list pgsql-sql

From A.Bhuvaneswaran
Subject Re: change a field
Date
Msg-id Pine.LNX.4.44.0309151026020.1123-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to change a field  (Patrick Meylemans <Patrick.Meylemans@wtcm.be>)
List pgsql-sql
Tree view 
> I want to change a field of a record after the modification of another 
> field of the same record or during an insert of a new record.

You can easily accomplish this in a BEFORE trigger. It is applicable for 
both insert & update.

regards,
bhuvaneswaran

pgsql-sql by date:

Previous
From: Rudi Starcevic
Date:
Subject: Re: Linked Lists example.
Next
From: Richard Huxton
Date:
Subject: Re: Plz, what is the most "correct" method