Trigger

From: "Andy Samuel" <andysamuel(at)geocities(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Trigger
Date: 2001-06-29 05:38:53
Message-ID: 000501c1005d$c8547020$0100a8c0@foserver
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How do I create a trigger on a table if a certain row is updated ?
For example, a table called DefaultValue with :
ModuleId char(10),
FieldId char(10),
DefVal char(3)

If I update the table 'update DefaultValue set defval='OFF' where
FieldId='MODULESTATUS' then it will fire the event.

Thank you in advance
Andy

Responses

  • Re: Trigger at 2001-06-29 08:54:09 from Feite Brekeveld

Browse pgsql-general by date

  From Date Subject
Next Message Igor 2001-06-29 05:51:46 How to check connection?
Previous Message Paul Tomblin 2001-06-29 01:06:24 Re: Re: useability of apache, PHP, Postgres for real business apps