You should use some variation of overlaps or
contains within. There is some discussion and
a list of operators in Issue #61 of General Bits.
( http://www.varlena.com/GeneralBits/61 )
I would also suggest looking at the geometric
operators in the documentation. You may have
to cast the polygon to
e this query using an explicit cast (State:S1000,
Native Code: 7)
I am not sure how to do this, any suggestions
Many thanks Dave
- Original Message -
From: "elein" <[EMAIL PROTECTED]>
To: "David" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday
What query would i have to use to search for an item using a polygon as a
parameter? (i.e a very large polygon that would identify smaller polygons
within it) ideally i would like to give postgresq a series of co-ordinates
and then have it return all those results whose polygons fall into that set