From: Hunter, Ray <rhunter@enterasys.com>
To: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: Functions and Triggers
Date: Wed, 20 Jun 2001 14:42:42 -0400
Message-ID: <59358A738F45D51186A30008C74CE2500A07A9@slc-exc1.ctron.com> (raw)
Is there anyone that can point me into the right direction for creating a
function and trigger that will do something along these lines:
I have a table that has router card types and a status on them:
TEST_RECORD
CARD STATUS
1. er16-04 0
2. er16-04 er16-08 1
3. ssr8000 ssr8600 0
4. er16-04 1
5. er16-04 ssr8600 0
6. er-16-04 1
I need a trigger with a function that will check the card type and status
and from there determine the over all status of the test in the test_table.
Each tuple represents one test on a specific card(s) and the status is pass
or fail.
Here the overall status that would be updated in the test_table status be
fail, because of the ssr8600 on line 5.
I appreciate any suggestions and/or comments.
RAY HUNTER
Automated Test Group
Software Support Engineer
ENTERASYS NETWORKS
Internal: 53888
Phone: 801 887-9888
Fax: 801 972-5789
Cellular: 801 698-0622
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: <59358A738F45D51186A30008C74CE2500A07A9@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