postgresql - Multiple rows in subquery -
i trying create context of exclusion zone in layer.
i trying following map file/sql combo
data "geom public.data" filter "layer = %layer_id% , st_contains(all(select the_geom public.exclusion_zone layer = %layer_id%), geom) != true"
obviously breaks when there more 1 exclusion zone, how do this?
i've tried storedproc's told mapserver can't find it's srid doesn't appear in geometry table
the error receiving thus
query error. error (error: more 1 row returned subquery used expression ) executing query
try this:
data "geom public.data" filter " layer = %layer_id% , not exists ( select * public.exclusion_zone layer = %layer_id% , st_contains(the_geom, geom) )
Comments
Post a Comment