[postgis-users] Finding the min point point along an line and ST_Line_Substring

[Mike Toews]

On 19 March 2015 at 21:10, <dave.potts at pinan.co.uk> wrote:
> I have a line string  geometry,  I am trying to find the min point between
> the start and end point of this line
>
> Can I use st_Line_substring(foo,0.5,0.5) to return the min point ?
>
> Are there any pit falls I should be aware of ?

You mean mid-point? It's more direct to use
ST_Line_Interpolate_Point(foo, 0.5) to get a point geometry.

I suppose be aware that in 2.1 this function was renamed to
ST_LineInterpolatePoint.

-Mike