Hi, The objective of the query is to find the roads that run along the state boundry. I have tried and written a query, can somebody give me suggestion on it. this below query runs but system hangs. i don't know what is wrong.
*select s.name from state s, road r where st_intersects(ST_Buffer(s.the_geom, 0.001),r.the_geom) and s.name ~* 'Nana'; * -Nicholas I
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
