[postgis-users] need a help

[Nicholas I]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081118/cf3b8429/attachment.html>