sbailliez/gist:0a741dc5e21b42ef6736

Created March 24, 2015 14:21

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/sbailliez/0a741dc5e21b42ef6736.js"></script>
Save sbailliez/0a741dc5e21b42ef6736 to your computer and use it in GitHub Desktop.

Download ZIP

Revisions

sbailliez created this gist Mar 24, 2015.

gistfile1.txt

-Original file line number
+Diff line change
@@ -0,0 +1,5 @@
+     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);