Re: trigger examples - Mailing list pgsql-sql

From drfrog@smartt.com
Subject Re: trigger examples
Date
Msg-id 39D9636B.5B45952C@smartt.com
Whole thread Raw
In response to trigger examples  (Carolyn Lu Wong <carolyn@kss.net.au>)
List pgsql-sql
Carolyn Lu Wong wrote:
> 
> I need to write a trigger to create a new record in log table if it's a
> new record or if column A and B changes. Can someone give me an example
> how to do this.
> 
> Are there any sites that gives trigger examples??
> 
> Thanks.

the fulltextindex in the contrib dir gives an example


pgsql-sql by date:

Previous
From: Carolyn Lu Wong
Date:
Subject: trigger examples
Next
From: Carolyn Lu Wong
Date:
Subject: DB backup and connection questions