booo/gist:1115871

Created July 30, 2011 19:10

Star (1) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/booo/1115871.js"></script>
Save booo/1115871 to your computer and use it in GitHub Desktop.

Download ZIP

sort on the value of an hstore

Raw

gistfile1.sql

SELECT id, tags->'amenity' AS value, tags FROM nodes WHERE tags ? 'amenity' ORDER BY tags->'amenity';

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment