Re: operator exclusion constraints

On Sun, 2009-11-01 at 18:07 -0500, Tom Lane wrote:
> Simon Riggs <simon@2ndQuadrant.com> writes:
> > The syntax be easier to read if it was stated as a comparison
> > e.g. in the circle example
> >   CHECK ( NOT (NEW.c && c)) USING GIST
> 
> I don't think this is a good idea at all.  NEW is a nonstandard
> Postgres-ism, and introducing it into this syntax doesn't seem very
> future-proof to me.  What's more, the above is not in the least
> analogous to a regular CHECK constraint, because there's some implicit
> notion of "c" ranging over all other rows, which is not what is meant
> by the same column reference in a CHECK constraint.
> 
> I agree that the proposed syntax is a bit awkward, but this isn't
> better.

Agreed. Just looking for readable, future-proof syntax.

-- Simon Riggs           www.2ndQuadrant.com