Re: Multiple Index's

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Multiple Index's
Дата
Msg-id Pine.BSF.4.10.10009211027070.62098-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Multiple Index's  ("Brian C. Doyle" <bcdoyle@mindspring.com>)
Список 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.



В списке pgsql-sql по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: sql query not using indexes
Следующее
От: Mark Volpe
Дата:
Сообщение: Re: Multiple Index's