Re: Exclusion Constraints on Arrays? - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: Exclusion Constraints on Arrays?
Date
Msg-id 53A5174B-13D6-411B-9F5A-1EEF312D2EE2@justatheory.com
Whole thread Raw
In response to Re: Exclusion Constraints on Arrays?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On May 23, 2012, at 10:35 AM, Robert Haas wrote:

>> "Exclusion constraints generalize uniqueness constraints by allowing
>> arbitrary comparison operators, not just equality....This is useful
>> for time periods and other ranges, as well as arrays."
>
> I objected to it at the time, but lost the argument.

It does rather seem to be a mistake to say that they can be used with arrays when they cannot. Or can they in some
otherway I haven’t noticed? 

David



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Readme of Buffer Management seems to have wrong sentence
Next
From: Jeff Janes
Date:
Subject: Re: Add primary key/unique constraint using prefix columns of an index