From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
---|---|
To: | Jim Nasby <decibel(at)decibel(dot)org> |
Cc: | "Jill" <jill289(at)hotmail(dot)com>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: check (constraint) on point data type? |
Date: | 2007-07-24 21:19:15 |
Message-ID: | F19890E1-0639-48AD-A3B6-366BCF79DA69@seespotcode.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
[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
From | Date | Subject | |
---|---|---|---|
Next Message | Jill | 2007-07-25 05:47:34 | Re: check (constraint) on point data type? |
Previous Message | Jim Nasby | 2007-07-24 21:10:57 | Re: check (constraint) on point data type? |