Re: operator exclusion constraints - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: operator exclusion constraints
Date
Msg-id 1257448147.28470.76.camel@monkey-cat.sm.truviso.com
Whole thread Raw
In response to Re: operator exclusion constraints  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: operator exclusion constraints
List 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 by date:

Previous
From: James Pye
Date:
Subject: Re: Typed tables
Next
From: "David E. Wheeler"
Date:
Subject: Re: operator exclusion constraints