Re: JSON query

2021-10-18 Thread Scott Ribe
> On Oct 18, 2021, at 10:02 PM, David G. Johnston > wrote: > > (jsonb - text[]) = ‘{}’::jsonb …? Aha, thank you!

Re: JSON query

2021-10-18 Thread David G. Johnston
On Monday, October 18, 2021, Scott Ribe wrote: > > "containing only keys from this list of keys" > > (jsonb - text[]) = ‘{}’::jsonb …? Combine with (jsonb ?& text[]) if all tested keys need to be present as well. David J.