| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | "Brian C(dot) Doyle" <bcdoyle(at)mindspring(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Multiple Index's |
| Date: | 2000-09-21 17:28:01 |
| Message-ID: | Pine.BSF.4.10.10009211027070.62098-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Thu, 21 Sep 2000, 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?
If you want the first data to go through, maybe a unique index on
(user_id, date) would work.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mitch Vincent | 2000-09-21 17:28:18 | Re: Multiple Index's |
| Previous Message | Stephan Szabo | 2000-09-21 17:26:20 | Re: sql query not using indexes |