Hi, I have two tables, one which define lines (ST_LineString) and a point (St_Points).
I'm searching to get the nearest line from this point. My first solution was to use this type of query : SELECT id, St_Distance(line, myPoint) d FROM my_lines_tables ORDER BY d ASC LIMIT 1 But it's very long. Is there is another way to make this ? Thank you all, Kin
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
