Can someone explain to me why jsonb_object_keys can limit my result set?
I would expect the following to return 2 rows:
1,3
2,null
But the last one is filtered out.
     SELECT
 idx,
        jsonb_object_keys(json_data::jsonb -> '2')
 FROM
     (
     SELECT 1 as idx, '{"1":"val","2":{"3": "val"}}' as json_data
         UNION ALL
     SELECT 2 as idx, '{"1":"val"}' as json_data
     ) a
Version: PostgreSQL 11.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-11), 64-bit