Re: Multiple Index's

CREATE TABLE user_info(user_id name, entry_date date, info text);
CREATE UNIQUE INDEX user_info_key ON user_info(user_id, entry_date);

"Brian C. Doyle" wrote:
>
> Hello all,
>
> How would I prevent a user from submitting information to a table once they
> have already done so for that day. I would need them to be able
> information on future dates as well as have information in the table from
> past dates from that user.
>
> I am looking for something like insert user_id, date, info where user_id
> and date are not the same... does that make sense?
>
> Brian C. Doyle