Sort on location

Lists: PostgreSQL : PostgreSQL 메일 링리스트 : 2014-02-26 이후 무지개 토토 21:45
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
Lists: PostgreSQL : PostgreSQL 메일 링리스트 : 2014-02-26 이후 무지개 토토 21:45

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.