Advertisement
Guest User

Untitled

a guest
Mar 26th, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. create table test (data jsonb);
  2. insert into test (data) values ('{"id": 1, "items":[{"a": 1, "b": 2}, {"a":3, "b": 4}]}');
  3. insert into test (data) values ('{"id": 2, "items":[{"a": 2, "b": 3}, {"a":4, "b": 5}]}');
  4. select * from test;
  5. data
  6. ----------------------------------------------------------
  7. {"id": 1, "items": [{"a": 1, "b": 2}, {"a": 3, "b": 4}]}
  8. {"id": 2, "items": [{"a": 2, "b": 3}, {"a": 4, "b": 5}]}
  9. (2 rows)
  10.  
  11. Looking for:
  12.  
  13. id | a | b
  14. ----------
  15. 1 | 1 | 2
  16. 1 | 3 | 4
  17. 2 | 2 | 3
  18. 2 | 4 | 5
  19.  
  20. Ideally creating a view into the db.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement