Re: JSON query

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: JSON query
Date: 2021-10-19 04:02:23
Message-ID: CAKFQuwaa1W7HqY=BY2FEXsRJkbL6pYfvwVqTF2g1-6adONMenQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Monday, October 18, 2021, Scott Ribe <scott_ribe(at)elevated-dev(dot)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.

In response to

  • JSON query at 2021-10-19 03:45:39 from Scott Ribe

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2021-10-19 04:25:32 Re: Where is the tsrange() function documented?
Previous Message Michael Paquier 2021-10-19 04:00:59 Re: Force re-compression with lz4