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

Popular posts from this blog

java - Run a .jar on Heroku -

java - Jtable duplicate Rows -

validation - How to pass paramaters like unix into windows batch file -