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 1qgW3G-00G6GU-NE for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Sep 2023 20:01:30 +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 1qgW3E-001z5M-JY for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Sep 2023 20:01:28 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qgW3E-001z4w-1r for pgsql-hackers@lists.postgresql.org; Wed, 13 Sep 2023 20:01:28 +0000 Received: from pb-smtp20.pobox.com ([173.228.157.52]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qgW39-004OCk-Hd for pgsql-hackers@lists.postgresql.org; Wed, 13 Sep 2023 20:01:25 +0000 Received: from pb-smtp20.pobox.com (unknown [127.0.0.1]) by pb-smtp20.pobox.com (Postfix) with ESMTP id F26631C4FE; Wed, 13 Sep 2023 16:01:20 -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=Qo34OaxxT2Ki93y8MNMJOuZwj/ 3I/87QWTjPyXiADTQ=; b=kT01FnYVMQcy64EsCqAdwF5R956R333q9pu2Yu5XoK wZJ0MCUfUFeSCebijRJdKnylqSrKJkR8d4A1AhIOazsagIsnRt6OYqPKBk7xnUsC 7DTGI+PvylHTEhAuPB7T/Ni7U0BDKO0u1XglTgSfEb2McKFYr/KITyWTyJFzaQ5o 4= Received: from pb-smtp20.sea.icgroup.com (unknown [127.0.0.1]) by pb-smtp20.pobox.com (Postfix) with ESMTP id EC3251C4FD; Wed, 13 Sep 2023 16:01:20 -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=Qo34OaxxT2Ki93y8MNMJOuZwj/3I/87QWTjPyXiADTQ=; b=SJb9IXHCgAdguBPYRkInO3VoN6IueuHX4efoXomeVAzVDHAga4yko+uo20tSfo3CRxvmgxXqdcr61m6oyi9wbi2xBsRIOLMhOh3ZI6M0+zzE2dqe+Wb4S2/yi736DIQM8QsuYvd5d6fdX+HSe8OBS5oCvdNzw9hUH0AIqOR0kzc= 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-smtp20.pobox.com (Postfix) with ESMTPSA id B15FA1C4FB; Wed, 13 Sep 2023 16:01:16 -0400 (EDT) (envelope-from david@justatheory.com) Content-Type: multipart/signed; boundary="Apple-Mail=_9948B5E6-AA2C-4065-B75C-791F11E1375C"; 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: <640942d7-c996-0562-62c9-d69a4c1f9b1e@xs4all.nl> Date: Wed, 13 Sep 2023 16:01:03 -0400 Cc: 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> To: Erik Rijkers X-Mailer: Apple Mail (2.3731.700.6) X-Pobox-Relay-ID: 4CA2C548-5270-11EE-8B2D-F515D2CDFF5E-76319746!pb-smtp20.pobox.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_9948B5E6-AA2C-4065-B75C-791F11E1375C Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 On Sep 13, 2023, at 01:11, Erik Rijkers wrote: > "All use of json*() functions preclude index usage." >=20 > That sentence is missing from the documentation. Where did that come from? Why wouldn=E2=80=99t JSON* functions use = indexes? I see that the docs only mention operators; why would the = corresponding functions behave the same? D --Apple-Mail=_9948B5E6-AA2C-4065-B75C-791F11E1375C 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+KfmbOQis6ZycGGkt9idPjIgfEFAmUCFP8ACgkQkt9idPjI gfECzxAAi6aisQmcrrEc3+CI7lKpKhIj1d0pBYG/DT2zszcR9DVnbvyxw91N6zWP 8pxuctyFsc1ZAg/C313AOOwKNxYeT2fup9irMs65Hp/Sp1Pwg1akGJbyRDahhKFE JhxuP/4LkuNv2srGH9PVxcwytnWZTgg2r6ax3hkjD7mtfY4zbU1loGkKwztoeElo 0SAiDSxpmzrrGlRPClw4ydwFFsulf9sKlpYhyeGPrmDVlP3Xzd4YY6I6dRZWBpMa WihQf2exNK1s4ZbrUh5Qgx8Z8EnNtLGOQBaOMTJSk7lvMgtiXYkE8BHV79rkrPZI onChwM4r2MQ5Btr2InGJnIQ1gg42h6khskl8TY8sQqqCqk1EnF+PWoIU5Pwp0Iyl 44PeG6yGEIVtY/DAw4SKrzVtiy7XA1tZ8TTsCRilVvz0rMojTJT01jVn+GZVzohl oensbTb9oQWNwhRUWZm9TvzMAAczPy9bFKfTthHtGm8A1jpgzq5/XFjhJ7dboJB1 Dx+ViTqOVaIHmsZlH8hkpkMwht5XXilv1JlmtvK7nSa2SKpWNxAHKNWfVP9oVJ+9 9uO00QSiLdobFEBnns2pmAlXkzglmv/pY/OXiJon9+UganCMF46liUceGWHWLhCy UG/Nyx0eBR7Itfsf+Ry7xOhwxQQPlqv7ZBk5Rzcm8pCwwDFAvMc= =N1Km -----END PGP SIGNATURE----- --Apple-Mail=_9948B5E6-AA2C-4065-B75C-791F11E1375C--