Skip to content

Instantly share code, notes, and snippets.

@jaredjburgess

jaredjburgess/pg_array_overlap.sql

Created February 21, 2016 14:37
Show Gist options
  • Save jaredjburgess/623b74927ab17568b493 to your computer and use it in GitHub Desktop.
Save jaredjburgess/623b74927ab17568b493 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL syntax to condition on the overlap of an array column with a given array
Raw
pg_array_overlap.sql
where array_column && array['string1', 'string2']::text[]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment