Dear Madam,
I had the same issue tonight.
I sorted it out, perhaps it may help you :)
Convert BOX to a polygon & insert some values as per the syntax.
Than run a query
SELECT polygon '((-3,10),(8,18),(-3,30),(-10,20))' @> point '(-8,25)';
let me know if this doesn't work for you ;)
Cheers!
Helen <[EMAIL PROTECTED]> writes:
> It's the point that's stored in the table - the query is to find all the
> points within a given box. I'm not sure what that means for indexing though,
> would that mean the point <@ box operator could be used with an index? if
> not, the polygon solution will
HST <[EMAIL PROTECTED]> writes:
> I am trying to write a query to find all points that fall within a
> given box. However, I cannot seem to find the functionality for
> determining whether a point is within a box.
> e.g. select box '((0,0),(1,1))' @> point '(0.5,0.5)';
> operator does not exist:
Hello
I am trying to write a query to find all points that fall within a
given box. However, I cannot seem to find the functionality for
determining whether a point is within a box.
e.g. select box '((0,0),(1,1))' @> point '(0.5,0.5)';
operator does not exist: box @> point
Is this operator for
