On Sun, 2009-11-01 at 18:07 -0500, Tom Lane wrote: > Simon Riggs <si...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers