Skip to content

Instantly share code, notes, and snippets.

@ionatan-israel

ionatan-israel/zipcodes.sql

Created May 17, 2017 14:16
Show Gist options
  • Save ionatan-israel/3949fda375f6918610104783db9614dd to your computer and use it in GitHub Desktop.
Save ionatan-israel/3949fda375f6918610104783db9614dd to your computer and use it in GitHub Desktop.
Download ZIP
Select in array field of postgresql
Raw
zipcodes.sql
SELECT *
FROM public.cities,
unnest(zip_codes) zip
WHERE lower(zip) LIKE '08411%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment