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 1rEvMb-007ez6-75 for pgsql-hackers@arkaria.postgresql.org; Sun, 17 Dec 2023 17:55:41 +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 1rEvMX-002Sq8-6f for pgsql-hackers@arkaria.postgresql.org; Sun, 17 Dec 2023 17:55:37 +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 1rEvMW-002Sod-Lu for pgsql-hackers@lists.postgresql.org; Sun, 17 Dec 2023 17:55:36 +0000 Received: from pb-smtp20.pobox.com ([173.228.157.52]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rEvMO-00CUhH-I6 for pgsql-hackers@lists.postgresql.org; Sun, 17 Dec 2023 17:55:34 +0000 Received: from pb-smtp20.pobox.com (unknown [127.0.0.1]) by pb-smtp20.pobox.com (Postfix) with ESMTP id 5562035932; Sun, 17 Dec 2023 12:55:23 -0500 (EST) (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 :content-transfer-encoding:message-id:references:to; s=sasl; bh= 0kDc5jHpxi6xnIwGgL5/Gf8/Ka5ps6YRmiMX4i2Je94=; b=QYDDjVs5qII8ld3p wM7jtyN41Nm91mv9TgmCcej2VeJ/bqnXz2fHjfctQHSroSdkgVYf0K2zptrUEfU2 BasrNkxfFpkvRg0SQb2ErhMuV/MFlAGsyU/Ka++Qd1RYqzrXVC7za7F2e+uIBfcw lyaY3JFsAth9xM0Mw1Y6BJuYv4g= Received: from pb-smtp20.sea.icgroup.com (unknown [127.0.0.1]) by pb-smtp20.pobox.com (Postfix) with ESMTP id 394FF35931; Sun, 17 Dec 2023 12:55:23 -0500 (EST) (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:content-transfer-encoding:message-id:references:to; s=2016-12.pbsmtp; bh=0kDc5jHpxi6xnIwGgL5/Gf8/Ka5ps6YRmiMX4i2Je94=; b=atLxaGCOywd/CmRuAIfFU8lAD8uw+6jY/mKa3P8o+nqNXI/5q+uAHxxGoDSCb9hFvoh8npCt68p0ac0RWyUc0nGCs+AuF6A/91nwKAhG/zgWVifBcvYzmcLbvX8oWdk7oc1DV0uCNgpMMsDv32kF8W3XbZ9ZZb74lWVu2xFUjNE= 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 7C5343592F; Sun, 17 Dec 2023 12:55:18 -0500 (EST) (envelope-from david@justatheory.com) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.200.91.1.1\)) Subject: Re: JSON Path and GIN Questions From: "David E. Wheeler" In-Reply-To: <636E83FD-DC39-48F2-8F81-ED133AF5289A@justatheory.com> Date: Sun, 17 Dec 2023 12:55:05 -0500 Cc: pgsql-hackers@lists.postgresql.org Content-Transfer-Encoding: quoted-printable 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> <3802532.1694812485@sss.pgh.pa.us> <8504C88E-A036-47F4-8FAE-9BA95F55CB03@justatheory.com> <3826235.1694824574@sss.pgh.pa.us> <4097442.1694967650@sss.pgh.pa.us> <636E83FD-DC39-48F2-8F81-ED133AF5289A@justatheory.com> To: Tom Lane X-Mailer: Apple Mail (2.3774.200.91.1.1) X-Pobox-Relay-ID: 70C681FA-9D05-11EE-BB43-F515D2CDFF5E-76319746!pb-smtp20.pobox.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sep 17, 2023, at 18:09, David E. Wheeler = wrote: > 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. >=20 > A header might be useful, something like =E2=80=9CWhat Counts as an = indexable expression=E2=80=9D. Hey Tom, are you still thinking about adding this bit to the docs? I = took a quick look at master and didn=E2=80=99t see it there. Thanks, David