title: Need Path in the form of Lat,long using pgrouting
body: <p>I am using this query for finding the path using postgresql , postgis, pgrouting, postgis_topology using nodejs</p>
  
  <pre><code>client.query(
  "WITH dijkstra AS (
    SELECT * 
    FROM pgr_dijkstra('SELECT id,source,target,distance AS cost 
       FROM edges_noded',230965,3338,false)) 
   SELECT seq, 
     CASE WHEN dijkstra.node = edges_noded.source THEN edges_noded.the_geom 
     ELSE ST_Reverse(edges_noded.the_geom) END AS route_geom 
   FROM dijkstra JOIN edges_noded ON(edge = id) 
   ORDER BY seq",(err,res)=&gt;{ var data = res.rows;})
  </code></pre>
  
  <p>now problem is that this query returns two columns which is</p>
  
  <p><a href="https://i.stack.imgur.com/FIRmW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FIRmW.png" alt="enter image description here"></a></p>
  
  <p>I think route_geom column in above above image has a information of path.</p>
  
  <p>How can I modified the above query to get path in the form of latitude and longitude.</p>
  
  <p>I need the complete path in the form of latitude and longitude.</p>