Re: Novice Help Needed

On Thu, 18 May 2000, Brian C. Doyle wrote:
> 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

If I understand, maybe you can just make a composite primary key out of userid
and date.

CREATE TABLE  atable (userid    INTEGER,thedate    TIMESTAMP,PRIMARY KEY (userid, thedate)
);
--  Robert B. Easter
reaster@comptechnews.com