Content-Type: multipart/signed;
	boundary="Apple-Mail=_8F26DDE7-053A-4162-8A12-7765F776426B";
	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" <david@justatheory.com>
In-Reply-To: <973d6495-cf28-4d06-7d46-758bd2615e34@xs4all.nl>
Date: Sat, 16 Sep 2023 16:19:23 -0400
Cc: Erik Wienhold <ewie@ewie.name>,
 pgsql-hackers@lists.postgresql.org
Message-Id: <B5F73DF7-A0CF-4EA2-AF5D-800BFEA67D47@justatheory.com>
References: <15DD78A5-B5C4-4332-ACFE-55723259C07F@justatheory.com>
 <133696180.303713.1694566807910@office.mailbox.org>
 <729CC2EA-9194-459C-B2A6-BC660F62E6A9@justatheory.com>
 <973d6495-cf28-4d06-7d46-758bd2615e34@xs4all.nl>
To: Erik Rijkers <er@xs4all.nl>
Archived-At: <https://www.postgresql.org/message-id/B5F73DF7-A0CF-4EA2-AF5D-800BFEA67D47%40justatheory.com>
Precedence: bulk


--Apple-Mail=_8F26DDE7-053A-4162-8A12-7765F776426B
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii

On Sep 15, 2023, at 23:59, Erik Rijkers <er@xs4all.nl> wrote:

> movie @? '$ ?($.year >=3D 2023)'
>=20
> I believe it is indeed not possible to have such a unequality-search =
use the GIN index.  It is another weakness of JSON that can be =
unexpected to those not in the fullness of Knowledge of the manual. Yes, =
this too would be good to explain in the doc where JSON indexes are =
explained.

Is that a limitation of GIN indexes in general? Or could there be =
opclass improvements in the future that would enable such comparisons?

Thanks,

David


--Apple-Mail=_8F26DDE7-053A-4162-8A12-7765F776426B
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+KfmbOQis6ZycGGkt9idPjIgfEFAmUGDcsACgkQkt9idPjI
gfHclQ//ffLHOP5PftswXZZbo/fP+czzrLiHzuuaKmRFuf/zSnKaIztN2m21f7Fp
K2AeZ3oYJgepaWlHfyZ2ml9JAfnyI4CZhHxLDlfzJ/XrrDh6+E0uFz7AwvodYzbr
yMVRLjTc8MyA48jp/O6i1hJTcnVZp236ZVYKMG2T0IQEJ/B5LZRD7lJKV31Gklor
ONynRQKfJ0npF7u1cUk5VDnFjC9QChLomPKNUjXV6LpdPf0dEDWAkcx+vtaYhWhJ
6JwKmFTsojM1ZVLY9Pt8MDafIiJTRoRzs1veYDhO5OtriG2f55WftrhdEvfH6sgV
UjMkUPG+sECTJN6W5FUZS+DLRyBwpkqVVZ9S8mlNxirtqdXAhypMLT+CEJdOqWNa
eYF87Z4mt0lRgobCsxzFOqYWLP6IglFH/UfJlPGsye7fsqBxByuI0Uy5eH7A8eHe
nCvTWEtsvAuc5mtV9IDR4B1yytVnHyr5nh9MRm0xxCMjeDvH6ic0geRKBMiBM5Wt
lOGR/QdUpQZd671srUNuGpVOT1gMFLKX7uwmP2nVfR17O/axVNpSptYTOkcz4qVp
8mcELVLsJVpb9WRwV9NABI7RJwLaMgop/P7soZAMuQ97K1L7JSrnkAGvBx2rJO4L
1xXTLg5CDw+/1iNFhIMo922qwnIZUPHJsCdKCOFD7NMuU/uWuno=
=fGCj
-----END PGP SIGNATURE-----

--Apple-Mail=_8F26DDE7-053A-4162-8A12-7765F776426B--