I couldn't find a topic related to my problem, thus I am going to ask. I have the following problem:
I need to create a new Point based on three variables: P1 (Geometry), P2 (Geometry) and length (Integer in meters). I know the geometry of two points and want to crate a new point the lies between them given a determined length, like in the picture below:
How can I do it using only Postgis?
I am using Postgis 2.2 with PostgreSQL 9.4.