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 f56KEeE12726 for ; Wed, 6 Jun 2001 16:14:40 -0400 (EDT) (envelope-from rhunter@enterasys.com) Received: (from uucp@localhost) by ctron-dnm.ctron.com (8.8.7/8.8.7) id QAA25869 for ; Wed, 6 Jun 2001 16:21:33 -0400 (EDT) Received: from cnc-exc1.ctron.com(134.141.77.96) by ctron-dnm.ctron.com via smap (4.1) id xma025846; Wed, 6 Jun 01 16:20:37 -0400 Received: by cnc-exc1.ctron.com with Internet Mail Service (5.5.2650.21) id ; Wed, 6 Jun 2001 16:13:37 -0400 Message-ID: <59358A738F45D51186A30008C74CE2500A0794@slc-exc1.ctron.com> From: "Hunter, Ray" To: "'Postres-sql' (E-mail)" Subject: Functions and Triggers Date: Wed, 6 Jun 2001 16:13:35 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C0EEC5.2BA8B5BE" X-Archive-Number: 200106/79 X-Sequence-Number: 3298 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_01C0EEC5.2BA8B5BE Content-Type: text/plain; charset="iso-8859-1" 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 ------_=_NextPart_001_01C0EEC5.2BA8B5BE Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Functions and Triggers

I need help on creating a sql function t= hat will check four rows in a table based on that check it will update anot= her row on a different table.  I want to use this function in a trigge= r statement.

Table 1 (Test Type)
id      cat &n= bsp;   sub-cat test        &nb= sp;   status          tim= estamp

Table 2 (Record)
timestamp     =   card    comp_date      = status


What I am trying to do is when someone e= nters 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 s= tatus 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:     &n= bsp; rhunter@en= terasys.com
 
www.enterasys.com<= /FONT>

------_=_NextPart_001_01C0EEC5.2BA8B5BE--