Sort on location

From: "Don Lapin" <donl(at)laduesystems(dot)net>
To: Sfpug <sfpug(at)postgresql(dot)org>
Subject: Sort on location
Date: 2014-02-26 21:45:07
Message-ID: 20140226214507.1396570739@mail.laduesystems.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug

Taking the example in the PostgreSQL documentation of cities and weather, how would you sort on the x and y values (in that order) of the location field?

SELECT * FROM cities ORDER BY ...;

Thank you.

Browse sfpug by date

  From Date Subject
Next Message Josh Berkus 2014-03-18 22:05:12 Upcoming SFPUGs: April, May, Momjian
Previous Message Josh Berkus 2014-02-10 22:04:46 Need help with upcoming meetups