Re: [SPAM]Re: Questions about 9.0 release note - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: [SPAM]Re: Questions about 9.0 release note
Date
Msg-id 4BB33AF50200002500030290@gw.wicourts.gov
Whole thread Raw
In response to Re: [SPAM]Re: Questions about 9.0 release note  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [SPAM]Re: Questions about 9.0 release note
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> wrote:
> This says:
> 
> Exclusion constraints ensure that that if any two rows are
> compared on the specified column(s) or expression(s) using the
> specified operator(s), not all of these comparisons will return
> <literal>TRUE</>.
> 
> I think that's backwards - the last clause should say "none of
> those comparisons will return <literal>TRUE</>".
> 
> Unless I'm confused.
"not all" seems correct.  For example, you could be checking the
room number for equality and a range of time for overlap -- both
must be TRUE to have a problem; otherwise you could only schedule
one thing in the room for all time and one thing at a given time
across all rooms.
-Kevin


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [SPAM]Re: Questions about 9.0 release note
Next
From: Robert Haas
Date:
Subject: Re: [SPAM]Re: Questions about 9.0 release note