title: How Do I Select Just a Latitude or Longitude From A Geography Point
body: <p>In Postgresql you can use <code>ST_TEXTFROMGEOGRAPHY</code> in a query to return a geography point in text form. Then whatever reads the query can parse the text to pull out the latitude and longitude of the geography point.</p>
  
  <p>When working with a geometry, you can use <code>ST_X</code> and <code>ST_Y</code> to return the x and y, respectively, of a geometry point as separate columns. I have not found a similar function for geography points.</p>
  
  <p>What is the simplest way to return two columns--a latitude column and a longitude column--from a geography instead of returning the geography as a single column?</p>