Hi, Using postgis 1.5 to update a table of points along a line with their fractional position along that line. I have confirmed that a select query returns good results:
select st_line_locate_point(a.the_geom, b.the_geom) as line_frac from road_table a, points_table b; This does not work properly however if I use an update query: update points_table set line_frac = st_line_locate_point(a.the_geom, b.the_geom) from road_table a, points_table b; In that case, the query still processes but all line_frac entries in points_table have what is the highest value in the select query; i.e. the value that should only belong to the point furthest down the road. Does anyone know what's going on here and how to fix it? Didn't find anything on this online. Thanks, Chris
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
