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 1su7bg-004KML-Ps for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Sep 2024 09:49:49 +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 1su7bf-006UGq-UL for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Sep 2024 09:49:47 +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 1su7bf-006UGa-KM for pgsql-hackers@lists.postgresql.org; Fri, 27 Sep 2024 09:49:47 +0000 Received: from fhigh-a4-smtp.messagingengine.com ([103.168.172.155]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1su7bc-001KuO-2R for pgsql-hackers@postgresql.org; Fri, 27 Sep 2024 09:49:47 +0000 Received: from phl-compute-11.internal (phl-compute-11.phl.internal [10.202.2.51]) by mailfhigh.phl.internal (Postfix) with ESMTP id 6E92311402CE; Fri, 27 Sep 2024 05:49:44 -0400 (EDT) Received: from phl-frontend-01 ([10.202.2.160]) by phl-compute-11.internal (MEProxy); Fri, 27 Sep 2024 05:49:44 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=justatheory.com; h=cc:cc:content-transfer-encoding:content-type:content-type :date:date:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:subject:subject:to:to; s= 2016-12.pbsmtp; t=1727430584; x=1727516984; bh=h22sltn51cUC+JvhJ xnNdka7dIRhD81LD3uhNX8aiq8=; b=WfQv5qALxrwnIuL5CI+cOs+CnhbTeYjSo Qv/8REXEFwBpsPI4HsTMPgDa6Rx2+HqdVWVUeFsC63W4OtROsUbmXCbiRHWTnneR 3e/bt+vbNE0aKahzYLvwcdiAX77inP4YXhELRuonmiojmAIAGEXJZ9YOYnQ2KdXQ Y763s1wnvc= DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pobox.com; h=cc :cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1727430584; x=1727516984; bh=h22sltn51cUC+JvhJxnNdka7dIRhD81LD3uhNX8aiq8=; b= i2ANb/bZ4y/IbFFiXA/DhrfvTpna4yL8yvQy32Oxd1E1cIswS1UBcz3FYoDnHKc3 8oBUIbb6/AE7ZRd4ncFzS7VaNT9Eya6ieAUnJLFi/oQSBSDABHvqalAHMPBpK76M RHMqWr0ZitMnMUiGajG8+ntl7YSaFUbVvX7ab0KHCEXwkMDUwTtK4lpkDzAVyq7l WtKHYpvFIF56QXSohEUbQNgxc94MpKnWZOZLnKOiaxeoqfv2qmRaTXZK+2S/Xu49 vTaY3B6f2AYcjnKI/rdQ+RVFyPWauccVtC2HZkdoNYKfXUOZsSQA4gZaujx6065I wmPEWcAe3PpLbNtnmjAPSA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1727430584; x= 1727516984; bh=h22sltn51cUC+JvhJxnNdka7dIRhD81LD3uhNX8aiq8=; b=G jmH8xa5noCrszp5Q8zOF8GOWM/9br4VW66fqbvfGtMPcYIZBKs4I2Fyp+41qj828 H3cNXq/u6sxMGvZzAknnwH9p6V2d23zTLjF9AWZhL1t72Atjqfo6g+S58ksr925s lyt+giRY56O6pAmR1f7GbYAFGqKJUD2EDa5Ka0ZysG+ohcn95ljR/BJ+khDEYpkN a2BFsPychev8jVfFicnR/a8Ulyx313DJzuuqKtpj84g+fejJLeEKr5SRjWpASrf4 /HpbSwCKoflBdSMYbYWWeQdNUpFFsNWeaSv01amuMYYGpxLnb9/QAJbcnc61E3Kf nnYE4X+UYIG4M073Urq9A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrvddtledgvddtucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnecujfgurheptggguffhjgffvefgkfhfvffosehtqhhmtdhhtdej necuhfhrohhmpedfffgrvhhiugcugfdrucghhhgvvghlvghrfdcuoegurghvihgusehjuh hsthgrthhhvghorhihrdgtohhmqeenucggtffrrghtthgvrhhnpeetveeigfdtueetudff jeetfeetudetjeeiudefgfetgeejkeelkeehudfguddvkeenucevlhhushhtvghrufhiii gvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegurghvihgusehjuhhsthgrthhhvgho rhihrdgtohhmpdhnsggprhgtphhtthhopeegpdhmohguvgepshhmthhpohhuthdprhgtph htthhopegrlhgvgigrnhgurhgrrdifrghnghdrohhsshesghhmrghilhdrtghomhdprhgt phhtthhopehpvghtvghrsegvihhsvghnthhrrghuthdrohhrghdprhgtphhtthhopehpgh hsqhhlqdhhrggtkhgvrhhssehpohhsthhgrhgvshhqlhdrohhrghdprhgtphhtthhopegr nhgurhgvfidrughunhhsthgrnhesvghnthgvrhhprhhishgvuggsrdgtohhm X-ME-Proxy: Feedback-ID: i7c334307:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 27 Sep 2024 05:49:43 -0400 (EDT) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3818.100.11.1.3\)) Subject: Re: SQL:2023 JSON simplified accessor support From: "David E. Wheeler" In-Reply-To: Date: Fri, 27 Sep 2024 10:49:31 +0100 Cc: Peter Eisentraut , PostgreSQL Hackers , Andrew Dunstan Content-Transfer-Encoding: quoted-printable Message-Id: <092FFD9C-88E2-4D8F-9445-53C9DE4C8EF1@justatheory.com> References: To: Alexandra Wang X-Mailer: Apple Mail (2.3818.100.11.1.3) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sep 26, 2024, at 16:45, Alexandra Wang = wrote: > I didn=E2=80=99t run pgindent earlier, so here=E2=80=99s the updated = version with the > correct indentation. Hope this helps! Oh, nice! I don=E2=80=99t suppose the standard also has defined an = operator equivalent to ->>, though, has it? I tend to want the text = output far more often than a JSON scalar. Best, David