I have a table with three points in it and I want to create a line from them using PostGIS.
when I try to create a line from this geometry using:
select id, st_makeline(geom order by id desc) as geom from public."point_table" group by id;
I get null geometery
What am I doing incorrectly?
PostGIS version 2.2.1 PostgreSQL version 9.5.1