From: Hunter, Ray <rhunter@enterasys.com>
To: 'Postres-sql' (E-mail) <pgsql-sql@postgresql.org>
Subject: Functions and Triggers
Date: Wed, 6 Jun 2001 16:13:35 -0400
Message-ID: <59358A738F45D51186A30008C74CE2500A0794@slc-exc1.ctron.com> (raw)
I need help on creating a sql function that will check four rows in a table
based on that check it will update another row on a different table. I want
to use this function in a trigger statement.
Table 1 (Test Type)
id cat sub-cat test status timestamp
Table 2 (Record)
timestamp card comp_date status
What I am trying to do is when someone enters data in on table 2 the trigger
will verifty the record and then look at all records with the same id and
card type, then it will determine the status of the test, or in other words
it will change the value of status in table 1.
Thanks,
RAY HUNTER
Automated Test Group
ENTERASYS NETWORKS
E-mail: rhunter@enterasys.com
www.enterasys.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rhunter@enterasys.com
Subject: Re: Functions and Triggers
In-Reply-To: <59358A738F45D51186A30008C74CE2500A0794@slc-exc1.ctron.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox