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 1rF0af-008162-Cp for pgsql-hackers@arkaria.postgresql.org; Sun, 17 Dec 2023 23:30:33 +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 1rF0ad-004Ldx-7c for pgsql-hackers@arkaria.postgresql.org; Sun, 17 Dec 2023 23:30:31 +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 1rF0ac-004Lda-Kn for pgsql-hackers@lists.postgresql.org; Sun, 17 Dec 2023 23:30:30 +0000 Received: from pb-smtp1.pobox.com ([64.147.108.70]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rF0aW-00AuS5-32 for pgsql-hackers@lists.postgresql.org; Sun, 17 Dec 2023 23:30:28 +0000 Received: from pb-smtp1.pobox.com (unknown [127.0.0.1]) by pb-smtp1.pobox.com (Postfix) with ESMTP id 0D73A1D0DC3; Sun, 17 Dec 2023 18:30:22 -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= a956xxWbVV7jzbe4VWhoy2tZ2t2PTOdA7cGp86ifewA=; b=G1UCyrGCtqHYna5C Ir8yHYY7pnwKbdkxca5NlOc9cshco6sOvxJ3bZ6oB9luqth3xLrtZ7PWoLkadytp Z9MS7sOF0CDM/g6KTdksJmjjVvmmMkLwCKi+VZUJUyWga7brpD+4fNSGRg1M4yUc HFuoeNfaMfu39vVNwz2vGXYRlH4= Received: from pb-smtp1.nyi.icgroup.com (unknown [127.0.0.1]) by pb-smtp1.pobox.com (Postfix) with ESMTP id 063741D0DC2; Sun, 17 Dec 2023 18:30:22 -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=a956xxWbVV7jzbe4VWhoy2tZ2t2PTOdA7cGp86ifewA=; b=EHmfNnAZCSleNjMQJeZc6ljw2vNHcbeTcrC4Kki5jQHCwiz6fRNeRXavrUWdPWlXEwxcTqmjTtZYfSmkKSvAIuUAQo6iHQYpL+ZyxLcNwvX8YIYxJ0SM9UfPAU1AcTvDkpNjMhuVWfIX/cRwYvqgpOEj6hTtZd9MZjJIHanY3p4= 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 7F9061D0DC1; Sun, 17 Dec 2023 18:30:21 -0500 (EST) (envelope-from david@justatheory.com) Content-Type: text/plain; charset=us-ascii 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: <3762206.1702847325@sss.pgh.pa.us> Date: Sun, 17 Dec 2023 18:30:10 -0500 Cc: pgsql-hackers@lists.postgresql.org Content-Transfer-Encoding: 7bit Message-Id: <9103BD24-4EBF-4652-81CA-051822BF995B@justatheory.com> 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> <3762206.1702847325@sss.pgh.pa.us> To: Tom Lane X-Mailer: Apple Mail (2.3774.200.91.1.1) X-Pobox-Relay-ID: 3EFE0894-9D34-11EE-B717-78DCEB2EC81B-76319746!pb-smtp1.pobox.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Dec 17, 2023, at 16:08, Tom Lane wrote: > I'd waited because the discussion was still active, and then it > kind of slipped off the radar. I'll take another look and push > some form of what I suggested. Right on. > That doesn't really address the > jsonpath oddities you were on about, though. No, I attempted to address those in [a patch][1]. [1]: https://commitfest.postgresql.org/45/4624/ Best, David