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(at)comptechnews(dot)com