Skip to content

Instantly share code, notes, and snippets.

@midhunkrishna

midhunkrishna/so_questions-41225833.sql

Created April 27, 2017 06:21
Show Gist options
  • Save midhunkrishna/077984da65c1307ff60a57cc10e0fae5 to your computer and use it in GitHub Desktop.
Save midhunkrishna/077984da65c1307ff60a57cc10e0fae5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
so_questions-41225833.sql
SELECT DISTINCT(each_attribute ->> 'reference_number_field')
AS reference_number
FROM deliveries
CROSS JOIN json_array_elements(reference_numbers)
AS each_attribute
WHERE (each_attribute -> 'reference_number_field')
IS NOT NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment