Skip site navigation (1) Skip section navigation (2)

Novice Help Needed

From: "Brian C(dot) Doyle" <bcdoyle(at)mindspring(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Novice Help Needed
Date: 2000-05-18 18:01:37
Message-ID: 4.3.1.2.20000518131444.00af6760@pop.mindspring.com (view raw or flat)
Thread:
Lists: pgsql-sql
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


Responses

pgsql-sql by date

Next:From: Michael A. MayoDate: 2000-05-18 18:32:47
Subject: Re: What is the difference between NULL and "undef"
Previous:From: Mitch VincentDate: 2000-05-18 17:25:28
Subject: Re: LIKE and regex

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group