Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qhFCB-001oH9-Dk for pgsql-hackers@arkaria.postgresql.org; Fri, 15 Sep 2023 20:13:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qhFC9-002ymN-Qw for pgsql-hackers@arkaria.postgresql.org; Fri, 15 Sep 2023 20:13:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qhFC9-002ym7-9F for pgsql-hackers@lists.postgresql.org; Fri, 15 Sep 2023 20:13:41 +0000 Received: from pb-smtp1.pobox.com ([64.147.108.70]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qhFC6-005JHV-3u for pgsql-hackers@lists.postgresql.org; Fri, 15 Sep 2023 20:13:40 +0000 Received: from pb-smtp1.pobox.com (unknown [127.0.0.1]) by pb-smtp1.pobox.com (Postfix) with ESMTP id 8FA151A0BFD; Fri, 15 Sep 2023 16:13:34 -0400 (EDT) (envelope-from david@justatheory.com) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed; d=pobox.com; h= content-type:mime-version:subject:from:in-reply-to:date:cc :message-id:references:to; s=sasl; bh=Zi2qsT+veZh4IuTdmtACgFrMh8 6s+R4qt70vd93cFRo=; b=ZAXa7y6dlsdz1SdrlhBdhGj5aAg41sPcLa9j27MEyT si8f8lWAWmWxJ6lE89wNZogrBrUVXNEwvelgY7ioOLPlzOa/5gcnkV5z4scMS958 3u1YqSSigFh7GZGCmUGdvW381XSOt0wI6wSeTjdW3USKWko7YNjvM9lOZeXShZSv Y= Received: from pb-smtp1.nyi.icgroup.com (unknown [127.0.0.1]) by pb-smtp1.pobox.com (Postfix) with ESMTP id 8800D1A0BFC; Fri, 15 Sep 2023 16:13:34 -0400 (EDT) (envelope-from david@justatheory.com) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed; d=justatheory.com; h=content-type:mime-version:subject:from:in-reply-to:date:cc:message-id:references:to; s=2016-12.pbsmtp; bh=Zi2qsT+veZh4IuTdmtACgFrMh86s+R4qt70vd93cFRo=; b=X+bOfOAVvzFTaujpK0QwEZqpjTvuY+9WKBuEVtQ+QhMNXvM5agM5Ze2guN8wPykdYcrXkj4c+xAzBVpgucGvqimS549aswplsoiXEVaBYXGG3tfzf1mJfkPEiKKr+2RR8WOOgCFi6I2kYhPuGMdyT9nX3RV3tM9W0uivIpyBHwQ= Received: from smtpclient.apple (unknown [158.222.197.125]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by pb-smtp1.pobox.com (Postfix) with ESMTPSA id F273D1A0BFB; Fri, 15 Sep 2023 16:13:33 -0400 (EDT) (envelope-from david@justatheory.com) Content-Type: multipart/signed; boundary="Apple-Mail=_5C76436A-DC9F-4CFD-8274-2245D96534AB"; protocol="application/pgp-signature"; micalg=pgp-sha256 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.700.6\)) Subject: Re: JSON Path and GIN Questions From: "David E. Wheeler" In-Reply-To: <3063408.1694666518@sss.pgh.pa.us> Date: Fri, 15 Sep 2023 16:13:22 -0400 Cc: Erik Rijkers , Erik Wienhold , pgsql-hackers@lists.postgresql.org Message-Id: References: <15DD78A5-B5C4-4332-ACFE-55723259C07F@justatheory.com> <133696180.303713.1694566807910@office.mailbox.org> <640942d7-c996-0562-62c9-d69a4c1f9b1e@xs4all.nl> <3063408.1694666518@sss.pgh.pa.us> To: Tom Lane X-Mailer: Apple Mail (2.3731.700.6) X-Pobox-Relay-ID: 58C3E416-5404-11EE-8301-78DCEB2EC81B-76319746!pb-smtp1.pobox.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_5C76436A-DC9F-4CFD-8274-2245D96534AB Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii On Sep 14, 2023, at 00:41, Tom Lane wrote: > As far as json in particular is concerned, 8.14.4 jsonb Indexing [4] > is pretty clear about what is or is not supported. How do you feel about this note, then? diff --git a/doc/src/sgml/json.sgml b/doc/src/sgml/json.sgml index b6c2ddbf55..7dda727f0d 100644 --- a/doc/src/sgml/json.sgml +++ b/doc/src/sgml/json.sgml @@ -413,6 +413,13 @@ SELECT doc->'site_name' FROM websites Two GIN operator classes are provided, offering = different performance and flexibility trade-offs. + + + As with all indexes, only operators on indexed columns are = considered as + index qualifications. In other words, only jsonb = operators can + take advantage of GIN indexes; jsonb functions cannot. + + The default GIN operator class for jsonb supports = queries with the key-exists operators ?, = ?| Best, David --Apple-Mail=_5C76436A-DC9F-4CFD-8274-2245D96534AB Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=signature.asc Content-Type: application/pgp-signature; name=signature.asc Content-Description: Message signed with OpenPGP -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEEd+KfmbOQis6ZycGGkt9idPjIgfEFAmUEuuIACgkQkt9idPjI gfFRmBAAhGvs1PSfWuWKYjme3vcayjvEBL4IbOGvOZGXWsiITl+z3zSoJlhAg9IL raLrQ2WzkLt7BO7ZoMaUVdFPJExmznPrpc0MJixDUi9uSY/Ut8UrvxsegyIwtMV4 37tshB4j5vtRuzKUc/YPgceeWqnGVyoZyMRF3Xh7AC/OBE6zdkKOlCBNP1Fb/Dr3 Hxtb8fzz64NpHm+6fwRwk6TAAnEn31+ErJ9OPdQEzVa8fRKbPMIJuMJH/raVvZyJ 1oazryibwDJObPJiPtVUfAi0ihxxKlZiX+zvtIMYVqvvLMjWj4JpysrYOiB4lXYN X7AbIJLtPr4tUNBeKcd8llY08RyINygcSHAs4Bqzp/1IsSV6yCaJSH6hb7oFebH4 1FQHYQlePhBpbXaL8bFzz3tJSNszGY2VgcTrW5Yysm1TGUILGtTurR7y4/2l5vIn wcn2Oo1HTZ5DsNvQKVqa2/tE1ZMyH/d4ngY5I9EbbhvVnDy2UQCGqSRyt4Rbal/Z SBYNVO07ANRJTiwoYVhhIMW3g5SFfdVUYx5c2slG44c0lKrNAdIhbBZYdOJTUsap 0Xp1eFTF4BTvh/K4mr8pQkfq2003hBg6YUnrHHjICPHNBNpZghV3Gv+1nnOaUsKe gGc0SAbPxMIW3DrbF7etw2qRU3m8LZTKZmiXlnB+ATuE+yxIWKY= =OEfP -----END PGP SIGNATURE----- --Apple-Mail=_5C76436A-DC9F-4CFD-8274-2245D96534AB--