Received: from smtp10.atl.mindspring.net (smtp10.atl.mindspring.net [207.69.200.246]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA03090 for ; Thu, 18 May 2000 13:58:25 -0400 (EDT) (envelope-from bcdoyle@mindspring.com) Received: from bec.mindspring.com (ip76.herndon29.va.pub-ip.psi.net [38.30.144.76]) by smtp10.atl.mindspring.net (8.9.3/8.8.5) with ESMTP id NAA08314 for ; Thu, 18 May 2000 13:58:24 -0400 (EDT) Message-Id: <4.3.1.2.20000518131444.00af6760@pop.mindspring.com> X-Sender: bcdoyle@pop.mindspring.com X-Mailer: QUALCOMM Windows Eudora Version 4.3.1 Date: Thu, 18 May 2000 14:01:37 -0400 To: pgsql-sql@postgresql.org From: "Brian C. Doyle" Subject: Novice Help Needed Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200005/61 Hello, I am in need of a rule or trigger that will only allow one entry where the date and a userid field are the same? So on the insert I want it to first check and see if userid and date exist and if so do not enter them. If they do exist, allow the insert Brian C. Doyle