Skip to content

Instantly share code, notes, and snippets.

@booo
Created March 7, 2012 00:06
Show Gist options
  • Select an option

  • Save booo/1989973 to your computer and use it in GitHub Desktop.

Select an option

Save booo/1989973 to your computer and use it in GitHub Desktop.
CREATE INDEX idx_nodes_tags_addr_postcode ON nodes ((tags->'addr:postcode')) WHERE (tags->'addr:postcode') IS NOT NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment