Re: operator exclusion constraints - Mailing list pgsql-hackers

From Robert Haas
Subject Re: operator exclusion constraints
Date
Msg-id 603c8f070911140955p1fcd20b6taac4762c6730a281@mail.gmail.com
Whole thread Raw
In response to Re: operator exclusion constraints  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: operator exclusion constraints
List pgsql-hackers
On Sat, Nov 14, 2009 at 12:11 PM, David E. Wheeler <david@kineticode.com> wrote:
> On Nov 14, 2009, at 8:55 AM, Tom Lane wrote:
>
>>> I've been meaning to comment on this syntax one more time; apologies for the bike-shedding. But I'm wondering if
the"CHECK" is strictly necessary there, since the WITH seems adequate, and there was some discussion before about the
CHECKkeyword possibly causing confusion with check constraints. 
>>
>> I had been manfully restraining myself from re-opening this discussion,
>> but yeah I was thinking the same thing.  The original objection to using
>> just WITH was that it wasn't very clear what you were doing "with" the
>> operator; but that was back when we had a different initial keyword for
>> the construct.  EXCLUDE ... WITH ... seems to match up pretty naturally.
>
> You're more man than I, Tom, but yeah, with EXCLUDE, WITH works well on its own, methinks.

I haven't thought about this too deeply, but could we allow the "with
=" part to be optional?  And would it be a good idea?  Seems like you
would commonly have one or more keys that exclude on equality and then
the last one would use an overlap-type operator.

...Robert


pgsql-hackers by date:

Previous
From: Roger Leigh
Date:
Subject: Re: Unicode UTF-8 table formatting for psql text output
Next
From: Tom Lane
Date:
Subject: Re: operator exclusion constraints