Changes between Version 1 and Version 2 of Ticket #29157, comment 4
- Timestamp:
- Mar 22, 2018, 8:40:04 AM (7 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #29157, comment 4
v1 v2 36 36 }}} 37 37 38 Or like this: 39 {{{ 40 # SELECT * FROM test WHERE '33' = ANY(SELECT jsonb_array_elements(test.size) ->> 'b'); 41 size 42 ------------------------------------------ 43 [{"a": 12, "b": 33}, {"a": 12, "b": 99}] 44 }}} 38 45 39 46 40 47 48