Re: psql option

2024-04-09 Thread Bruce Momjian
On Wed, Apr 10, 2024 at 12:01:39AM +0200, Daniel Gustafsson wrote: > > On 9 Apr 2024, at 18:33, Daniel Gustafsson wrote: > > > >> On 9 Apr 2024, at 16:05, PG Doc comments form > >> wrote: > >> > >> The following documentation comment has been logged on the website: > >> > >> Page:

Re: psql option

2024-04-09 Thread Daniel Gustafsson
> On 9 Apr 2024, at 18:33, Daniel Gustafsson wrote: > >> On 9 Apr 2024, at 16:05, PG Doc comments form wrote: >> >> The following documentation comment has been logged on the website: >> >> Page: https://www.postgresql.org/docs/16/app-psql.html >> Description: >> >> option -X, >> >> the

Re: psql option

2024-04-09 Thread Daniel Gustafsson
> On 9 Apr 2024, at 16:05, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/16/app-psql.html > Description: > > option -X, > > the specified comma after the letter X > >

psql option

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/app-psql.html Description: option -X, the specified comma after the letter X https://www.postgresql.org/docs/current/app-psql.html

Re: Postgres_FDW doc doesn't specify TYPE support in Remote Execution Options

2024-04-09 Thread Rajan Pandey
Hi team . In the https://www.postgresql.org/docs/current/postgres-fdw.html#POSTGRES-FDW-OPTIONS-REMOTE-EXECUTION doc, it mentions that Immutable Functions and Hi can be pushed down using `extensions` option for foreign server. But it does not mention TYPE. In the shippable.c

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":