Updating from a column - Mailing list pgsql-general

From Bob Pawley
Subject Updating from a column
Date
Msg-id BC92B1E0A0B54AA19141934F8CAC0EAC@desktop
Whole thread Raw
Responses Re: Updating from a column  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Hi
 
I have a table that has one column (pump1) controlled by a dbcheckbox. The values can be True, False or null.
 
I want to insert a row of values into second table when column pump1 value is 'True'. I don't want the trigger to insert a row when other columns of the first table are updated or when the pump1 column value becomes 'False'.
 
I would appreciate any suggestions as to how to accomplish this.
 
Thanks in advance.
 
Bob
 
 

pgsql-general by date:

Previous
From: Rodrigo Valdenegro
Date:
Subject: PostreSQL PostgreSQL 8.1.18 and Tsearch2 context error
Next
From: Vick Khera
Date:
Subject: Re: number of page slots needed (1576544) exceeds max_fsm_pages (204800)]