[postgis-users] Selecting polygons circled by one only polygons

[strk]

On Thu, Oct 28, 2010 at 12:07:04PM +0200, Andrea Peri wrote:

> I need to detect all the polygon that are inside a hole of another polygon.

You could make a temporary table containing only holes (as multipolys),
then check which polys in the original table
are contained by polys in the temporary table 

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html