Re: operator exclusion constraints

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: operator exclusion constraints
Дата
Msg-id 1257448147.28470.76.camel@monkey-cat.sm.truviso.com
обсуждение исходный текст
Ответ на Re: operator exclusion constraints  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: operator exclusion constraints
Список pgsql-hackers
On Thu, 2009-11-05 at 09:56 -0500, Tom Lane wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
> > Ooh, that's kind of neat.  But I think you'd need EXCLUSIVE (a, b) BY
> > (=, =), since it could equally well be EXCLUSIVE (a, b) BY (=, &&).
> 
> Yeah, we definitely want some parentheses delimiting the expression.
> EXCLUSIVE still feels like the wrong part-of-speech though.  How
> about EXCLUDING (...) BY ... instead?

I think EXCLUDING conflicts with the EXCLUDING in LIKE. Also, it becomes
a little more difficult to place the access method clause, because
"EXCLUDING USING gist" doesn't sound great.

Regards,Jeff Davis



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

Предыдущее
От: James Pye
Дата:
Сообщение: Re: Typed tables
Следующее
От: "David E. Wheeler"
Дата:
Сообщение: Re: operator exclusion constraints