title: Postgis, convert point to line
body: <p>well,</p>
  
  <p>I have points or coordinates from latitude and longitude. I wanted to combine two points to create lines using something like this:</p>
  
  <p>select gid,st_makeline (geom) from(select gig,long,lat,geom from capa0 order by gid) t1group by gid</p>
  
  <p>But I don't know if I'm okay.</p>
  
  <p>If anyone could help me, I would be very grateful.</p>
  
  <p>thanks</p>