Is there a way to get line segments from a linestring using points with lat/lng coordinates?
ST_Line_Substring is taking float8 start/end points. Is there a way to replace the float8 with lat/lng? I have also seen ST_pointN but I have random points that are not the same as the linestrng edges. ST_Split is useful but I need to install postgis 2.0 and that will require a configuration of my whole system which is in my plan but not yet..