Changes between Initial Version and Version 1 of Ticket #29157, comment 4
- Timestamp:
- Mar 21, 2018, 8:10:01 AM (6 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #29157, comment 4
initial v1 30 30 [{"a": 12, "b": 33}, {"a": 12, "b": 99}] 31 31 (1 row) 32 # SELECT test.* FROM test, jsonb_array_elements(test.size) where value->> 'b' = '11';32 # SELECT test.* FROM test, jsonb_array_elements(test.size) elems where elems ->> 'b' = '11'; 33 33 size 34 34 ------