Re: operator exclusion constraints - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: operator exclusion constraints
Date
Msg-id 20091105145030.GH3694@alvh.no-ip.org
Whole thread Raw
In response to Re: operator exclusion constraints  (Robert Haas <robertmhaas@gmail.com>)
List 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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: operator exclusion constraints
Next
From: Dimitri Fontaine
Date:
Subject: Re: Shall we just get rid of plpgsql's RENAME?