Hi ! I have a working query, which gives me roads crossed by a line between to points, and I want to order these results by distance from the first point to the roads.
select rue.* from troncons_routes rue where intersects(rue.the_geom,(select makeline(a.the_geom, b.the_geom) from points_toto a, points_toto b where a.nom='Geocia' and b.nom = 'Gare SNCF')) ORDER BY rue.nom_rue_g, st_distance(a.the_geom,rue.the_geom); everything works fine, but the last part, where it seems to miss an entry at the clause "from" for table 'a' (that's what pgadmin's query editor says) which I set up already. Can someone help me, please ? Hope you understand my question, regards, Guillaume
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
