[postgis-users] St_intersection

Bob Pawley rjpawley at shaw.ca
Mon Mar 19 10:44:22 PDT 2012


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

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

More information about the postgis-users mailing list