Changes between Initial Version and Version 1 of Ticket #24462, comment 9


Ignore:
Timestamp:
May 31, 2021, 1:29:00 PM (3 years ago)
Author:
Jameel A.

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #24462, comment 9

    initial v1  
    1 I believe we have a similar need, but for difference reasons.
     1I believe we have a similar need, but for different reasons.
    22
    33We have a JSONB postgres column and want to `jsonb_array_elements` followed by filtering. Because `jsonb_array_elements` expands into a set of columns, you cannot apply a `where` clause filter on the function column. A simple solution is to use `jsonb_array_elements` in a subquery and then filter the resulting subquery.
Back to Top