Hi:
I have a jsonb columne with json object like belo
{"a": 1, "b":2, "c":3}
I'd like to get subset of the object with key list ["a","c"]
so it retruns json object of
{"a": 1, "c":3}
something like
select '{"a": 1, "b":2, "c":3}'::jsob ->'["a","c"]'
what would be the most efficient (and simplest if possible) to get the
subset with the key list?
Thanks