Received: from ctron-dnm.ctron.com (ctron-dnm.cabletron.com [12.25.1.120]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5KGkFa94058 for ; Wed, 20 Jun 2001 12:46:15 -0400 (EDT) (envelope-from rhunter@enterasys.com) Received: (from uucp@localhost) by ctron-dnm.ctron.com (8.8.7/8.8.7) id MAA07226 for ; Wed, 20 Jun 2001 12:53:20 -0400 (EDT) Received: from unknown(134.141.77.96) by ctron-dnm.ctron.com via smap (4.1) id xma007190; Wed, 20 Jun 01 12:52:33 -0400 Received: by cnc-exc1.ctron.com with Internet Mail Service (5.5.2650.21) id ; Wed, 20 Jun 2001 12:45:25 -0400 Message-ID: <59358A738F45D51186A30008C74CE2500A07A5@slc-exc1.ctron.com> From: "Hunter, Ray" To: "'Postres-sql' (E-mail)" Subject: Functions and Triggers Date: Wed, 20 Jun 2001 12:45:20 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C0F9A8.679B14D4" X-Archive-Number: 200106/312 X-Sequence-Number: 3584 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C0F9A8.679B14D4 Content-Type: text/plain; charset="iso-8859-1" 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 ------_=_NextPart_001_01C0F9A8.679B14D4 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Functions and Triggers

Is there anyone that can point me into t= he right direction for creating a function and trigger that will do somethi= ng along these lines:

I have a table that has router card type= s and a status on them:

TEST_RECORD
        C= ARD             &nbs= p;             = STATUS
1.      er16-04 &nb= sp;             = ;  0
2.      er16-0= 4 er16-08         1
3.      ssr800= 0 ssr8600         0
4.      er16-0= 4              =    1
5.      er16-0= 4 ssr8600         0
6.      er-16-= 04             =            1

I need a trigger with a function that wi= ll check the card type and status and from there determine the over all sta= tus 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 up= dated in the test_table status be fail, because of the ssr8600 on line 5.

I appreciate any suggestions and/or comm= ents.

 
 
RAY HUNTER
Automated Test Group
Software Support Engineer
 
ENTERASYS NETWORKS
 
Internal:     53888=
Phone:     &nb= sp; 801 887-9888
Fax:      = ;    801 972-5789
Cellular:     = 801 698-0622
E-mail:     &n= bsp; rhu= nter@enterasys.com
 
www.enterasys.com<= /FONT>

------_=_NextPart_001_01C0F9A8.679B14D4--