From: | Erik Rijkers <er(at)xs4all(dot)nl> |
---|---|
To: | "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>, PostgreSQL Advocacy <pgsql-advocacy(at)lists(dot)postgresql(dot)org> |
Subject: | Re: PostgreSQL 14 Beta 1 release announcement draft |
Date: | 2021-05-18 10:33:24 |
Message-ID: | 257535a3-eafd-ee83-075f-133d909ec2d1@xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy |
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
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan S. Katz | 2021-05-18 21:11:31 | Re: PostgreSQL 14 Beta 1 release announcement draft |
Previous Message | SAS | 2021-05-18 06:43:37 | Re: PostgreSQL 14 Beta 1 release announcement draft |