Обсуждение: Novice Help Needed

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

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