On 17/05/13 00:05, Dave Potts wrote:
Found a different
solution select count(*) from route_table rt ,
avoid_areas av
where av.valid=true and rt.parent_port_id=80360 and
st_intersects(av.geom,((rt.the_geom))) =false
will answer the same question.
but I would still like to known why I get that error
D.
Hi,
I am trying to find the results of an intersection between a multi
line string and a polygon, I had assumed that saying something
like
select rt.source,
av.geom,st_astext(st_startpoint((st_dump((rt.the_geom))).geom)) from
route_table rt ,
avoid_areas av
where av.valid=true and rt.parent_port_id=80360 and
st_within(av.geom,st_startpoint((st_dump((rt.the_geom))).geom)) =true
might work where rt.the_geom is a multiline and av.geom is a polygon
but I get the error,
ERROR: argument of AND must not return a set
LINE 4: st_within(av.geom,st_startpoint((st_dump((rt.the_geom))).geo
any idea what I am doing wrong?
Dave
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
