Re: 8.14.5 jsonb subscripting

2024-04-10 Thread Arne Sommerfelt
Thank you all for super prompt and friendly support. Best regards Arne tir. 9. apr. 2024 kl. 16:26 skrev Tom Lane : > Arne Sommerfelt writes: > > Thank you! When googling it is easy to end up with latest docs, > > unfortunately > > That's actually good news --- it used to be that Google would

Re: 8.14.5 jsonb subscripting

2024-04-09 Thread Tom Lane
Arne Sommerfelt writes: > Thank you! When googling it is easy to end up with latest docs, > unfortunately That's actually good news --- it used to be that Google would tend to steer people to very ancient versions of our docs. Sounds like the SEO work that we've done is paying off. However, if

Re: 8.14.5 jsonb subscripting

2024-04-09 Thread David G. Johnston
On Tuesday, April 9, 2024, Arne Sommerfelt wrote: > Thank you! When googling it is easy to end up with latest docs, > unfortunately > The 12 is a hyperlink so it is almost just as easy to view the current page in the prior version. David J.

Re: 8.14.5 jsonb subscripting

2024-04-09 Thread Arne Sommerfelt
Thank you! When googling it is easy to end up with latest docs, unfortunately Arne tir. 9. apr. 2024 kl. 16:06 skrev Daniel Gustafsson : > > On 9 Apr 2024, at 16:04, Arne Sommerfelt > wrote: > > > > 12 is in the list of supported versions at the top of chapter 8.14. And > the non-working

Re: 8.14.5 jsonb subscripting

2024-04-09 Thread Daniel Gustafsson
> On 9 Apr 2024, at 16:07, Arne Sommerfelt wrote: > > OK, sorry if am making unnecessary noise. Since my version was listed as > supported I assumed the docs was valid for me. No worries, we're all here to learn. The "supported version" means that 12 is a version which the project still

Re: 8.14.5 jsonb subscripting

2024-04-09 Thread Arne Sommerfelt
OK, sorry if am making unnecessary noise. Since my version was listed as supported I assumed the docs was valid for me. Thanks for your help cheers Arne tir. 9. apr. 2024 kl. 16:04 skrev Daniel Gustafsson : > > On 9 Apr 2024, at 16:02, Arne Sommerfelt > wrote: > > > > > Thats the

Re: 8.14.5 jsonb subscripting

2024-04-09 Thread Daniel Gustafsson
> On 9 Apr 2024, at 16:04, Arne Sommerfelt wrote: > > 12 is in the list of supported versions at the top of chapter 8.14. And the > non-working examples is in subsection 8.14.5 I think you've misunderstood the header of the page. This is the documentation you should be reading for your

Re: 8.14.5 jsonb subscripting

2024-04-09 Thread Daniel Gustafsson
> On 9 Apr 2024, at 16:02, Arne Sommerfelt wrote: > Thats the documentation for v16, not the version you are running. -- Daniel Gustafsson

Re: 8.14.5 jsonb subscripting

2024-04-09 Thread Tom Lane
Arne Sommerfelt writes: > I am running on AWS RDS - it says engine version 12.17 i thought that was > the postgres version. If so, the [] subscripting should be supported > according to docs. According to what docs? Generic subscripting was added in v14. regards, tom

Re: 8.14.5 jsonb subscripting

2024-04-09 Thread Arne Sommerfelt
I checked with SELECT VERSION(); and got: PostgreSQL 12.17 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-12), 64-bit tir. 9. apr. 2024 kl. 15:05 skrev Arne Sommerfelt : > I am running on AWS RDS - it says engine version 12.17 i thought that was > the postgres

Re: 8.14.5 jsonb subscripting

2024-04-09 Thread Arne Sommerfelt
I am running on AWS RDS - it says engine version 12.17 i thought that was the postgres version. If so, the [] subscripting should be supported according to docs. Arne tir. 9. apr. 2024 kl. 13:16 skrev Laurenz Albe : > On Tue, 2024-04-09 at 09:31 +, PG Doc comments form wrote: > > Page:

Re: 8.14.5 jsonb subscripting

2024-04-09 Thread Laurenz Albe
On Tue, 2024-04-09 at 09:31 +, PG Doc comments form wrote: > Page: https://www.postgresql.org/docs/16/datatype-json.html > > Using subscripts with square brackets is not supported, one must use -> or > #> operators > The given examples result in error: > > SELECT ('{"a": 1}'::jsonb)['a']; >

8.14.5 jsonb subscripting

2024-04-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/datatype-json.html Description: Using subscripts with square brackets is not supported, one must use -> or #> operators The given examples result in error: SELECT ('{"a":

Re: Typo in examples in "8.14.5. jsonb Subscripting"

2022-07-10 Thread Michael Paquier
On Thu, Jul 07, 2022 at 12:27:01AM +, PG Doc comments form wrote: > Towards the end of the section, the code examples given have comments where > the JSON is using single quotes instead of double quotes around the > properties. For example this: > > -- Where jsonb_field was {}, it is now

Typo in examples in "8.14.5. jsonb Subscripting"

2022-07-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/datatype-json.html Description: Towards the end of the section, the code examples given have comments where the JSON is using single quotes instead of double quotes around the properties.