<HTML><HEAD></HEAD>
<BODY dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Arial Narrow'; COLOR: #00002b; FONT-SIZE: 12pt">
<DIV>Hi</DIV>
<DIV> </DIV>
<DIV>I am querying a geometry looking for intersection point between a line and
an other geometry.</DIV>
<DIV> </DIV>
<DIV>The return is 2 points and 2 linestrings. (when I use st_union a geometry
collection results)</DIV>
<DIV> </DIV>
<DIV>Can anyone tell me under what conditions that a st_intersection would
return a linestring??</DIV>
<DIV> </DIV>
<DIV>insert into num_search (the_geom3)</DIV>
<DIV>select st_intersection(Num_Search.the_geom1, entities.wkb_geometry) </DIV>
<DIV>from entities, Num_Search</DIV>
<DIV>where Num_Search.seq = 'R'</DIV>
<DIV>and st_intersects(entities.wkb_geometry, Num_Search.the_geom1) = True</DIV>
<DIV> </DIV>
<DIV>Bob</DIV></DIV></DIV></BODY></HTML>