Postgres Pro
Downloads
Home   >   mailing lists

Re: JSON query - Mailing list pgsql-general

From David G. Johnston
Subject Re: JSON query
Date
Msg-id CAKFQuwaa1W7HqY=BY2FEXsRJkbL6pYfvwVqTF2g1-6adONMenQ@mail.gmail.com
Whole thread Raw
In response to JSON query  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: JSON query
List pgsql-general
Tree view
On Monday, October 18, 2021, Scott Ribe <scott_ribe@elevated-dev.com> 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.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Where is the tsrange() function documented?
Next
From: Adrian Klaver
Date:
Subject: Re: Where is the tsrange() function documented?