Re: operator exclusion constraints

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: operator exclusion constraints
Дата
Msg-id 20091105145030.GH3694@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: operator exclusion constraints  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas escribió:
> On Thu, Nov 5, 2009 at 9:01 AM, Peter Eisentraut <peter_e@gmx.net> wrote:

> > Or as table constraint
> >
> > EXCLUSIVE (a, b) BY =
> >
> > And then you could think of UNIQUE as "EXCLUSIVE BY default-equals-op".
> >
> > EXCLUSIVE is already a key word, by the way.
> 
> 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 (=, &&).

Perhaps EXCLUSIVE (a BY =, b BY =)

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: operator exclusion constraints
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: Shall we just get rid of plpgsql's RENAME?