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 a circle to use the operators, but it will still tell you whether the smaller polys are contained within or overlap the larger. elein On Tue, Feb 17, 2004 at 07:01:51PM -0000, David wrote: > 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 > of co-ordinates, is this possible? > > at the moment all i can think of is > > > select * from species where location between '(0,0)' and '(1000,0)' and > '(0, 1000)' and '(1000; 1000)'; > > I think im way off, any suggestions? > > Cheers Dave > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend