Hello postgis list! I have a large query, it was going good, but I wanted to add a restriction to a path, this my WHERE clause: WHERE ST_Distance_Sphere(ST_GeomFromText('POINT($lat1 $lng1)'), ST_Line_Substring(re.path, 0, 0.5)) < $rad1 and ST_Distance_Sphere(ST_GeomFromText('POINT($lat2 $lng2)'), ST_Line_Substring(re.path, 0, 0.5)) < $rad2 and ST_Line_Locate_Point(ST_Line_Substring(re.path, 0, 0.5), 'POINT($lat1 $lng1)') < ST_Line_Locate_Point(ST_Line_Substring(re.path, 0, 0.5), 'POINT($lat2 $lng2)')
the $vars get replaced with good values. When I don't use the ST_Line_Substring, I don't get an error, but when I use it, I get "ERROR: 2nd arg must be smaller then 3rd arg". I assume that someway in someplace something is not understanding that 0 is smaller than 0.5, but I really don't see the error in anyway. Has anyone an indea of what is going on? Thanks!! :D _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users