Horton
Menu

Re: operator exclusion constraints

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Peter Eisentraut <peter_e@gmx.net>, Jeff Davis <pgsql@j-davis.com>, Simon Riggs <simon@2ndquadrant.com>, pgsql-hackers@postgresql.org
Date: 2009-11-05T14:56:21Z
Lists: pgsql-hackers 
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?

			regards, tom lane