Trigger - Mailing list pgsql-general

From Andy Samuel
Subject Trigger
Date
Msg-id 000501c1005d$c8547020$0100a8c0@foserver
Whole thread Raw
List 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




pgsql-general by date:

Previous
From: Paul Tomblin
Date:
Subject: Re: Re: useability of apache, PHP, Postgres for real business apps
Next
From: Igor
Date:
Subject: How to check connection?