Re: check (constraint) on point data type?

[Please don't top post as it makes the discussion more difficult to
follow.]

On Jul 24, 2007, at 16:10 , Jim Nasby wrote:

> What's wrong with (NOT location <@ box '((0,0),(1,1))') ?

Two reasons I didn't provide that answer:

1)

On Jul 24, 2007, at 2:06 PM, Michael Glaesemann wrote:

> I haven't looked at the geometric functions closely enough to see
> if you could use some of those rather than defining your own
> helper, but this should work.

2) I misread the specs and assumed that 0 and 1 values for x and y
were to be rejected. I suspected that the geometric functions were
inclusive rather than exclusive, which, upon experimentation, was
correct. Right answer to the wrong specs :)

# select not '(0,0)'::point <@ '((0,0),(1,1))'::box;
?column?
----------
f
(1 row)

Michael Glaesemann
grzm seespotcode net