Re: operator exclusion constraints

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Re: operator exclusion constraints
Дата
Msg-id 192B332B-F22F-4445-A5DF-FA3D088E73A6@kineticode.com
обсуждение исходный текст
Ответ на Re: operator exclusion constraints  (Jeff Davis <pgsql@j-davis.com>)
Ответы Re: operator exclusion constraints
Re: operator exclusion constraints
Список pgsql-hackers
On Nov 6, 2009, at 10:42 AM, Jeff Davis wrote:

> Right now, I am leaning toward Form 2, and EXCLUSION/BY. So the  
> typical
> case would read like:
>
>  EXCLUSION USING gist (room, during) BY (=, &&)

I like this, but like EXCLUDE better
    EXCLUDE USING gist (room, during) BY (=, &&)

Is your objection to EXCLUDE for cases when there is no USING clause?
    EXLUDE (room, during) BY (=, &&)

Yes, I can see how that'd be a bit more confusing. So EXCLUSION  
probably is best.

BTW, is it the case that room maps to = and during maps to && in this  
example? If so, wouldn't it make more sense to combine them?
    EXCLUSION (room WITH =, during WITH &&)

Or am I misunderstanding how this works (quite likely, I'm sure).

Best,

David



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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: operator exclusion constraints
Следующее
От: Tom Lane
Дата:
Сообщение: Re: operator exclusion constraints