[postgis-users] St_intersection

[Bob Pawley]

Hi

I am querying a geometry looking for intersection point between a line and an other geometry.

The return is 2 points and 2 linestrings. (when I use st_union a geometry collection results)

Can anyone tell me under what conditions that a st_intersection would return a linestring??

insert into num_search (the_geom3)
select st_intersection(Num_Search.the_geom1, entities.wkb_geometry) 
from entities, Num_Search
where Num_Search.seq = 'R'
and st_intersects(entities.wkb_geometry, Num_Search.the_geom1) = True

Bob
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120319/398df5ab/attachment.html>