I have a
LineString geometry which is
U shaped like and I'd like to find the center point of the geometry which lies on the LineString. I've already used
st_centroid but the returned geometry isn't on the LineString.
I would like to know which function should be used in PostGIS to achieve that?