Changes between Version 1 and Version 2 of Ticket #29157, comment 4


Ignore:
Timestamp:
Mar 22, 2018, 8:40:04 AM (6 years ago)
Author:
Dmitry Dygalo

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #29157, comment 4

    v1 v2  
    3636}}}
    3737
     38Or 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}}}
    3845
    3946
    4047
     48
Back to Top