Updating from a column

From: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
To: "Postgresql" <pgsql-general(at)postgresql(dot)org>
Subject: Updating from a column
Date: 2010-01-18 19:31:57
Message-ID: BC92B1E0A0B54AA19141934F8CAC0EAC@desktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2010-01-18 19:43:11 Re: number of page slots needed (1576544) exceeds max_fsm_pages (204800)]
Previous Message Rodrigo Valdenegro 2010-01-18 19:00:57 PostreSQL PostgreSQL 8.1.18 and Tsearch2 context error