Re: trigger examples

From: Carolyn Lu Wong <carolyn(at)kss(dot)net(dot)au>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: trigger examples
Date: 2000-10-03 07:05:24
Message-ID: 39D98534.31BC8197@kss.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

drfrog(at)smartt(dot)com wrote:
>
> 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

The example uses C. Is it possible to create the trigger with plpsql
function?

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Nema, Vivek 2000-10-03 08:16:02 -query sql
Previous Message Carolyn Lu Wong 2000-10-03 05:27:20 DB backup and connection questions