[postgis-users] Getting argument of AND must not return a set, when trying to calculate the intersection of a end of a multiline and a polygon

Dave Potts dave.potts at pinan.co.uk
Thu May 16 16:23:10 PDT 2013


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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users



More information about the postgis-users mailing list