Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lj70E-0004Cb-L1 for pgsql-advocacy@arkaria.postgresql.org; Tue, 18 May 2021 21:11:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lj70D-00057K-Li for pgsql-advocacy@arkaria.postgresql.org; Tue, 18 May 2021 21:11:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lj70D-00057C-7o for pgsql-advocacy@lists.postgresql.org; Tue, 18 May 2021 21:11:45 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lj709-0002O6-3y for pgsql-advocacy@lists.postgresql.org; Tue, 18 May 2021 21:11:44 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:MIME-Version:Date: Message-ID:From:References:To:Subject:Sender:Reply-To:Cc: Content-Transfer-Encoding:Content-ID:Content-Description; bh=KfWztXUl6On7+OhTpcmbsLpYLCgjVm85h8AU6oNaSG8=; b=Lexu4rv4HmdupWJpMFXRoyI16c YubwblIYp5NZyjeovO622IhgtX+aAiodoBuZv9Bji/6TX/2XtRvVpj0vPUxObs5acq+bLvGXDHPS3 ssDXSQMY/hLUtFQdcdjJM0opWG6TSSmvjrRRDVQefT3e3lERiFz3dtbe4w8bd8SmSHYneiOyTbV+/ g/SRiOYlxbYrwgc3Lr1+YLJo4kFs1QjLMb8wozvvzjiBjxBI0qrgUNkT1XnIIPQVknd0uNBiIiJ1p Fa3na4Wb8P8UF9AmjJO8udIrr0WJBhka88ADpDzgR9CAGPfKp4HeHP+WgpjSEi19qRSwDRvClQB2U 5M19IkzQ==; Received: from [70.19.69.80] (helo=[192.168.1.153]) by meldrar.postgresql.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lj705-0003NB-LZ; Tue, 18 May 2021 21:11:39 +0000 Subject: Re: PostgreSQL 14 Beta 1 release announcement draft To: Erik Rijkers , PostgreSQL Advocacy References: <257535a3-eafd-ee83-075f-133d909ec2d1@xs4all.nl> From: "Jonathan S. Katz" Message-ID: Date: Tue, 18 May 2021 17:11:31 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:78.0) Gecko/20100101 Thunderbird/78.10.1 MIME-Version: 1.0 In-Reply-To: <257535a3-eafd-ee83-075f-133d909ec2d1@xs4all.nl> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="XKNCNH4velZ0cWruCT5ZKjbjIOLBByG27" X-Host-Lookup-Failed: Reverse DNS lookup failed for 70.19.69.80 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --XKNCNH4velZ0cWruCT5ZKjbjIOLBByG27 Content-Type: multipart/mixed; boundary="tA7FBU8c40qTfUwePwI71NCU07OxhAT02"; protected-headers="v1" From: "Jonathan S. Katz" To: Erik Rijkers , PostgreSQL Advocacy Message-ID: Subject: Re: PostgreSQL 14 Beta 1 release announcement draft References: <257535a3-eafd-ee83-075f-133d909ec2d1@xs4all.nl> In-Reply-To: <257535a3-eafd-ee83-075f-133d909ec2d1@xs4all.nl> --tA7FBU8c40qTfUwePwI71NCU07OxhAT02 Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable On 5/18/21 6:33 AM, Erik Rijkers wrote: >=20 > 14beta1.md mentions subscripting: >=20 > "PostgreSQL 14 now adds a general subscripting framework for retrieving= > information in nested objects. For example, using the `JSONB` data type= > with, > you now are able to retrieve nested info just using the `.` operator (e= =2Eg. > `this.now.works.to.retrieve.this.json.data`)." >=20 > Is this correct?=C2=A0 I thought the provided JSON subscripting functio= nality > is: Oops -- great catch, that's 100% on me and my failure to read/test. I'll get a modified example into the announcement. Thanks, Jonathan --tA7FBU8c40qTfUwePwI71NCU07OxhAT02-- --XKNCNH4velZ0cWruCT5ZKjbjIOLBByG27 Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmCkLYMFAwAAAAAACgkQ8QSccp8cZSek XRAAm71SszSd9GoVyJTDlgY77sUBOb98Hx3KhukMax7NGgiDyFSvepjiY+adJhcPzRudNNsxy2gq eqU07yMQgkN7FlW9QFUAdAlRkTtMReDZ88U6Q4Pq1S+N2876yHgFExfJQ2N3t5LyVOla0ZZEn2wN foshC17bvppNQrLNwoyrRvwmO/+CqzKmpBdjBwK/TloZ3fYSViFpNpV0WhYcnF+S+uKubqL6px5M kFEQrq9e1rziyVj286CSzxQIuuL9ZkfMtyO9Mbyzhub9deWA2B3xBCjNc97XKb12QmuK/VU9mRvi siYdqfPA0Qbl6Hjf2Vi63dzMsGAqYUEGKcPXCcfyFO8YlS8Y3VQbnn7mo2jUouc4TmAuj9CIOhTc 39ZfVhCZFpDTl/I7FGIosEd8wYbT0geQydBVdP1Vpeiw2CryHDr/oAAOqL8zcKpXqss0A0KBFm8r UvUFtQJngyAq+uNVX60BSKSktEm2QXXwgFqUCjnpSclemHH2sx6jzbYAs/fWwerFhRoQG4qWYyiw sdne4vt1l+Yi2lNuSeMNgrfOMYor3ZcO8jy8irHtwHpAwkelVoGveA6PsiyCdcH/2FLAmUuZoF8p P7mC1vMkYjCwwu0M8kK9QwH7hotE5oUIEyw+a/jJB3nRCZepR8GeETgAdzDw2mIGwGKJeV46Uklw 2Ic= =f9yq -----END PGP SIGNATURE----- --XKNCNH4velZ0cWruCT5ZKjbjIOLBByG27--