From: | "Hunter, Ray" <rhunter(at)enterasys(dot)com> |
---|---|
To: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Functions and Triggers |
Date: | 2001-06-20 18:42:42 |
Message-ID: | 59358A738F45D51186A30008C74CE2500A07A9@slc-exc1.ctron.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)enterasys(dot)com
www.enterasys.com
From | Date | Subject | |
---|---|---|---|
Next Message | Kristoff Bonne | 2001-06-20 18:44:05 | pl/pgsql question (functions) |
Previous Message | Alex Pilosov | 2001-06-20 17:43:37 | Re: Re: binary data |