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 1su8pQ-004WBe-OA for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Sep 2024 11:08:05 +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 1su8pO-007Rz2-G8 for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Sep 2024 11:08:02 +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 1su8pN-007Ryu-Tu for pgsql-hackers@lists.postgresql.org; Fri, 27 Sep 2024 11:08:02 +0000 Received: from mail-qv1-xf35.google.com ([2607:f8b0:4864:20::f35]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1su8pK-001JAf-Nb for pgsql-hackers@postgresql.org; Fri, 27 Sep 2024 11:08:00 +0000 Received: by mail-qv1-xf35.google.com with SMTP id 6a1803df08f44-6cb2e5d0104so12812396d6.3 for ; Fri, 27 Sep 2024 04:07:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dunslane-net.20230601.gappssmtp.com; s=20230601; t=1727435276; x=1728040076; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:autocrypt:content-language :from:references:cc:to:subject:user-agent:mime-version:date :message-id:from:to:cc:subject:date:message-id:reply-to; bh=2bRFWCXQaaRfVC4U6m4dOvzNaHPNNfxL/tGxY6QIBkM=; b=YlQdkDqnlmKsfKutAW7W4JjO7iDrfOYWQUJ/PI0LA607GxGlDkpyGBU1gZZgSjemLv c3Po+Gt4to1fAWP4PJ+4ZqmUlNU39hfHDip/fvf9LTDiHralwrPvACO6qsz6n175QdSM FHsufPGnYs5GMXS+WdGkrvYCKpYlfImfRDb0Iff1HUp6ZQI+5ZgE6o652UiDzhccQkud N2uSu/mP5ZGjo0eNZ2L54uShDq3pUf+cKIUb8As/UvV2yfitTb+ZSDRoqft+Gwcw80lv l+e/PjQX2fRw5MLetZpWLj94q4XNHKCBeaElGBo+D0rhelX524+eKqJHMYpuN/SlrZG8 MiXw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1727435276; x=1728040076; h=content-transfer-encoding:in-reply-to:autocrypt:content-language :from:references:cc:to:subject:user-agent:mime-version:date :message-id:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=2bRFWCXQaaRfVC4U6m4dOvzNaHPNNfxL/tGxY6QIBkM=; b=hSjzX8DeAp4cctndBkBs13SF2HClR6CcXAmpjUCuOlPl675/FiziKWdHDhcPf8Z/Vz 742be8fkUf9RTKUUHMTY+uuemA8GDhfWErQ0TTZIQ3K/3oZ9s92lKEl0cXEpswZgCj+P cCnX1063TqHL7FtpMfNrviHB3mwv9SHxjUOQlJ9mHSE/sHJiszFkGvXewLl0oB7DKWpc yQl/8PPv8a1QMNnAEzsMfcU3PtmZ/LOOk4hecdiu5EsYc96FKtOjAG7WBkFjuMyufDlR ua2Mw+DYRfERPSFP3kFuMmTlcEzKoCFNLjxYMyIsZlJCxYrvZxLyeWUMIkv5FdKvphDN w+ug== X-Forwarded-Encrypted: i=1; AJvYcCXqov+uRj+Ds4z1G+xTYJE0dLSGpye28uTONFuZd4yWQyBhYNtVL+rISZXt22XZcPTh64skgRvRGg2wq9d3@postgresql.org X-Gm-Message-State: AOJu0YzSJ4r9vUze80iv1L8AMApif8Ap/Tg9d14rHPZMjnTx4r5pVbmJ usY5v7TGTJlUTlGHHMz+hOr8I3KDAymZHvBSXJVeeakTlTB+E3PvNg8NmOHbX+U= X-Google-Smtp-Source: AGHT+IH+5U6pzRBPxB/bzPBJ6XB4pPwC0UhzqBGTOwdwS/LMIJc2SrCbGrnYaIq6qtCzbtqkVJZyZQ== X-Received: by 2002:a05:6214:5d0e:b0:6c7:c76b:97d9 with SMTP id 6a1803df08f44-6cb3b63d923mr32535546d6.37.1727435276131; Fri, 27 Sep 2024 04:07:56 -0700 (PDT) Received: from ?IPV6:2605:a601:9180:9800::2bb? ([2605:a601:9180:9800::2bb]) by smtp.googlemail.com with ESMTPSA id 6a1803df08f44-6cb3b681767sm7479156d6.105.2024.09.27.04.07.53 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 27 Sep 2024 04:07:54 -0700 (PDT) Message-ID: Date: Fri, 27 Sep 2024 07:07:51 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: SQL:2023 JSON simplified accessor support To: "David E. Wheeler" , Alexandra Wang Cc: Peter Eisentraut , PostgreSQL Hackers , Andrew Dunstan References: <092FFD9C-88E2-4D8F-9445-53C9DE4C8EF1@justatheory.com> From: Andrew Dunstan Content-Language: en-US Autocrypt: addr=andrew@dunslane.net; keydata= xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB AAHNJEFuZHJldyBEdW5zdGFuIDxhbmRyZXdAZHVuc2xhbmUubmV0PsLAmwQTAQgARQIbAwIX gAIZAQULCQgHAgMiAgEGFQoJCAsCBBYCAwECHgcWIQTkPlhGHfx8v0RpFaWZ+n/LWfw7gQUC ZFlxxwUJGVGAbgAKCRCZ+n/LWfw7gXikB/9ZdcUy6CTBFIIuL/bVsc1eLEW/gJBjJBF6HxNY xgEkAgXAp4Lg4A5U+QB9GouFr7+GYxF0BU4hzoGhNPUWltxnHdMWP8nC/38LAqgMi8L/bbsm HW5YPBdWYaAZAPJQVfOAgjTbRUb26KSprpyrrJKW0ZmrZfjhNPcQ72jpWzoPLQqx2X6B0fru 1jq+cBh8lb6r1mJTim1T3JIn+F/v5VpdQS+EL8xqsHkfzKjIPsW3CIXpkypSk6saA55Rkkbl 26AW8ftPVB0Q6Lnn6FLt9CP0MGNixBQ55yq8r1K+nCBvCCjvQjM8RDm0UUum0WNl+ifQgTLO E8TWEnwVtkBf+3QWzsBNBE7KWFkBCADRnOM0FCzsYW6jtncg+dWIagjUZpvaClmqn/sJluLa Q3v1VXMQJzYs3eC1gh386W+XBwLRpDj3jzH81lX+p73Re3d3oJW7X+ffsxuzu5ZVdMUkqBYo nkAbKxr6gyJ12F/+JkUVzLcoTN+d/7YsQvUVi7NaKH8mJgjz112O4fUe3p9wfAaFa0RXHc5S GPzRTYRRlv/XZBIho4J2tkZOnteZJZ+GbxQVlINt6fd8P6al3MWOvpP/ExJPguEfjOsO6Njy xjo3WfpD4lHMOR/Oc3/8mScEF84rF2jXbsFgelWnbPWAvXY+pD0dXOFRkagGmC/viwBDqq5b 5tk76kKmUbZxABEBAAHCwHwEGAEIACYCGwwWIQTkPlhGHfx8v0RpFaWZ+n/LWfw7gQUCZFlx 5wUJGVGAjgAKCRCZ+n/LWfw7gf+iB/4g8CPY5jihf5r/8EsoIGe2H+dpVmpPF8YGBzTIvCz/ fQoOq8AX/pE76QEuFnFZWfjw+wgBXgCVmkox2Eflkk6z4ND3pcwGZ6CfCxTQCDk/dij+2DQ4 6bmDCy/sBgcbz9mTpoLC11HLoPae6YN9nBNQRZDcEFEu54OaVOqlIdbA6m+POIBCXZdHOFc0 WoDTgxHRzC1jgQNidyd6tKqcsVJs0dzF0oKTmFFmUAqTdJO12LBuNA1rlqrR3EtpYk8B/wtS 5dIMD7Q8hwQpL+4C6GNpb6ZKnPkLi47pDOLhz2qBrqN+rqUEsT3YnExYpzj5yOBi+FlmV1Hw 49QYe1sn2ZPs In-Reply-To: <092FFD9C-88E2-4D8F-9445-53C9DE4C8EF1@justatheory.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2024-09-27 Fr 5:49 AM, David E. Wheeler wrote: > On Sep 26, 2024, at 16:45, Alexandra Wang wrote: > >> I didn’t run pgindent earlier, so here’s the updated version with the >> correct indentation. Hope this helps! > Oh, nice! I don’t 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. > That would defeat being able to chain these. cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com