Content-Type: multipart/signed;
	boundary="Apple-Mail=_8E959787-1AC7-4A00-BEA0-04095AA28BEF";
	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: <4097442.1694967650@sss.pgh.pa.us>
Date: Sun, 17 Sep 2023 18:09:36 -0400
Cc: pgsql-hackers@lists.postgresql.org
Message-Id: <636E83FD-DC39-48F2-8F81-ED133AF5289A@justatheory.com>
References: <15DD78A5-B5C4-4332-ACFE-55723259C07F@justatheory.com>
 <133696180.303713.1694566807910@office.mailbox.org>
 <640942d7-c996-0562-62c9-d69a4c1f9b1e@xs4all.nl>
 <C4BBA1CB-9EA1-4124-8CAD-8DDD646C453F@justatheory.com>
 <aab40650-d292-3ece-e398-af2da8888e08@xs4all.nl>
 <3063408.1694666518@sss.pgh.pa.us>
 <D791AD43-8DE9-4358-A77C-5BC5D82AFA73@justatheory.com>
 <3802532.1694812485@sss.pgh.pa.us>
 <8504C88E-A036-47F4-8FAE-9BA95F55CB03@justatheory.com>
 <3826235.1694824574@sss.pgh.pa.us>
 <EE76F3CF-5C80-49E1-A472-315D54EE5111@justatheory.com>
 <4097442.1694967650@sss.pgh.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/636E83FD-DC39-48F2-8F81-ED133AF5289A%40justatheory.com>
Precedence: bulk


--Apple-Mail=_8E959787-1AC7-4A00-BEA0-04095AA28BEF
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

On Sep 17, 2023, at 12:20, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> After thinking about it for awhile, I think we need some more
> discursive explanation of what's allowed, perhaps along the lines
> of the attached.  (I still can't shake the feeling that this is
> duplicative; but I can't find anything comparable until you get
> into the weeds in Section V.)
>=20
> I put the new text at the end of section 11.1, but perhaps it
> belongs a little further up in that section; it seems more
> important than some of the preceding paras.

I think this is useful, but also that it=E2=80=99s worth calling out =
explicitly that functions do not count as indexable operators. True by =
definition, of course, but I at least had assumed that since an operator =
is, in a sense, syntax sugar for a function call, they are in some sense =
the same thing.

A header might be useful, something like =E2=80=9CWhat Counts as an =
indexable expression=E2=80=9D.

Best,

David


--Apple-Mail=_8E959787-1AC7-4A00-BEA0-04095AA28BEF
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+KfmbOQis6ZycGGkt9idPjIgfEFAmUHeSAACgkQkt9idPjI
gfEcRA/9Em7I4qrlm0hGeVl56xTAsQAgdTKgBY98nmMkV++gC0BMyHmW8qlnifWe
gPsYIZbBvciEEz+E1Qismd5BClacySYAXMAsauv1JURVCLH0WTMv9mRtX+ivxQKf
C4jwGxjO+Li/Iap+NbpgbN0dM7wyKQbzScRQSHmXeNOgslZAi/ee14TZw9k1EQKH
a1zR7M3zfEwubEVcA88tRLwie+tH21fpVZ3kcMmZBc1p3lxGeDBaMxrmb5xiJDLB
In4VkSJz7JUAHkjcEDjwIBbE7xpm1iKzWd0SUup1HX7RMaKrq0UnIbV0kO7suDe7
+Fe55wTPDRbBdo+Eh6qS1yj3F5ZebmHO+2ZoqPIS1T2CaJgF9NGE6BF15oglgeVm
hzL+BrjxOkF4f/R6FL9IkyZl2VhovxXSS5D5ailY/9UxGD+Lb/nR5STLubunvMpu
w1Mdoff4NgupOe/SDTgnWvzXPhwaj7ZoH0Trbj3N4dP/mz0keVz+1gZbj2glkYie
vmNF8SmOTd6qWTxa3ot1vD4+qPjchERsqADORrOcSQ5SQeB9An7SaBhAGFOK5lLU
iaYww/YwXuhj/f4sBkyzZPFLJcFqVmLZ0erazOGZ6buN984gcTNUeJzFCm7fVt5J
Q4oY2PP+wAG7HNG255rAjGeJd4IwCLtx34faFrKtS9+nXZTRQYw=
=hdCv
-----END PGP SIGNATURE-----

--Apple-Mail=_8E959787-1AC7-4A00-BEA0-04095AA28BEF--