Subject: Re: PostgreSQL 14 Beta 1 release announcement draft
From: Erik Rijkers <er@xs4all.nl>
To: "Jonathan S. Katz" <jkatz@postgresql.org>,
 PostgreSQL Advocacy <pgsql-advocacy@lists.postgresql.org>
References: <f82ccf97-d02c-0974-27b8-e0f5e4c1de02@postgresql.org>
 <ace2bead-c03d-84d3-fc20-90518c76c477@xs4all.nl>
Message-ID: <257535a3-eafd-ee83-075f-133d909ec2d1@xs4all.nl>
Date: Tue, 18 May 2021 12:33:24 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.10.0
MIME-Version: 1.0
In-Reply-To: <ace2bead-c03d-84d3-fc20-90518c76c477@xs4all.nl>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/257535a3-eafd-ee83-075f-133d909ec2d1%40xs4all.nl>
Precedence: bulk


14beta1.md mentions subscripting:

"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.g.
`this.now.works.to.retrieve.this.json.data`)."

Is this correct?  I thought the provided JSON subscripting functionality is:

select
     jsonb_pretty(js)
   , js['this']
   , js['this']['now']
   , js['this']['now']['works']
   , js['this']['now']['works'][1]
from
   (values ('{"this": { "now": {"works": [1,2] } } }'::jsonb)) as f(js)
;
       jsonb_pretty      |             js             | js         |   
js   | js
------------------------+----------------------------+-------------------+--------+----
  {                     +| {"now": {"works": [1, 2]}} | {"works": [1, 
2]} | [1, 2] | 2
      "this": {         +| |                   |        |
          "now": {      +| |                   |        |
              "works": [+| |                   |        |
                  1,    +| |                   |        |
                  2     +| |                   |        |
              ]         +| |                   |        |
          }             +| |                   |        |
      }                 +| |                   |        |
  }                      | |                   |        |
(1 row)

Where can the `.` operator be used in JSON(B)? What did I miss?


Erik Rijkers


On 5/17/21 5:01 PM, Erik Rijkers wrote:
> On 5/17/21 4:15 PM, Jonathan S. Katz wrote:
>> Please see the attached draft for the PostgreSQL 14 Beta 1 release
>> announcement this week.
>
> [..]
>
> Here are a few changes:
>
>
> when the `async_capable` flag is it.  should be:
>
> when the `async_capable` flag is set.
>
>
> can on foreign tables.   should be:
> on foreign tables.
>
>
> using the `JSONB` data type with,   should be:  using the `JSONB` data 
> type,
>
>
> Admittedly I am not a native speaker but that I do not understand
>
> 'bubble' is perhaps reason to rephrase?
>
>
> command in can now   should be:
> command can now
>
>
> Thank you,
>
> Erik Rijkers
>
>
>
>
>