Skip to content

Instantly share code, notes, and snippets.

@sbailliez

sbailliez/gist:0a741dc5e21b42ef6736

Created March 24, 2015 14:21
Show Gist options
  • Save sbailliez/0a741dc5e21b42ef6736 to your computer and use it in GitHub Desktop.
Save sbailliez/0a741dc5e21b42ef6736 to your computer and use it in GitHub Desktop.
Download ZIP
index on element of json array ?
Raw
gistfile1.txt
SELECT so._id AS order_id,
oi.value ->> 'id'::text AS id,
(oi.value -> 'sku_id'::text) ->> '$oid'::text AS sku_id,
FROM orders so,
LATERAL jsonb_array_elements(so._extra_props -> 'order_items'::text) oi(value);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment