I have a query which return me two dimension data:
SELECT POINT(value , extract(EPOCH FROM datetime)) AS pseudo_geom FROM table
pseudo_geom --------------- (18,1439679940) (29,1439680000) (16,1439680060)
What I would like to do is to convert these data into a
path type to be able to simplificate through ST_Simplify which accept a geometry type.
My goal is actually to reduce the number of points to display on a graph.
I tried with the path function and playing around with point(), string_agg() and grouping my data, with no result...
What could be the easiest and shortest way to do this?