Re: Detecting whether a point is in a box. - Mailing list pgsql-general

From hrsuprith
Subject Re: Detecting whether a point is in a box.
Date
Msg-id 1299723178686-3422647.post@n5.nabble.com
Whole thread Raw
In response to Detecting whether a point is in a box.  (HST <helenst@gmail.com>)
List pgsql-general
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!
Rao

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Detecting-whether-a-point-is-in-a-box-tp1887472p3422647.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Sean Hsien
Date:
Subject: Re: 9.0 streaming replication problem
Next
From: abcdef
Date:
Subject: output screen in psql