Re: Minor suggestions for docs regarding json_table

2025-02-18 Thread Amit Langote
On Sat, Feb 15, 2025 at 12:20 AM Robert Treat wrote: >> Given this, I think we should leave the path name documentation as it >> is for now and address it, if needed, as part of the patch for the >> PLAN clause. I'll go ahead and push your other fixes as in the >> attached patch. >> > > Ah, thanks

Re: Minor suggestions for docs regarding json_table

2025-02-14 Thread Robert Treat
On Fri, Feb 14, 2025 at 3:00 AM Amit Langote wrote: > On Sun, Feb 9, 2025 at 12:59 AM Robert Treat wrote: > > So, how does this thing get used? AFAIK there is no way to reference > > these aliases at the query level, instead they only show up within > > EXPLAIN VERBOSE output. Below is said outp

Re: Minor suggestions for docs regarding json_table

2025-02-14 Thread Amit Langote
On Sun, Feb 9, 2025 at 12:59 AM Robert Treat wrote: > So, how does this thing get used? AFAIK there is no way to reference > these aliases at the query level, instead they only show up within > EXPLAIN VERBOSE output. Below is said output, where you'll see that > the aliases I provided show up at

Re: Minor suggestions for docs regarding json_table

2025-02-10 Thread Miłosz Chmura
Thnx! All makes sense now. I guess that if something like `$$.fav.book.writer.name` was implemented to make absolute paths possible then the alias would be more useful. But I still did not think of an example of when that would be actually needed :) In any case, your patch looks great to me. Thank

Re: Minor suggestions for docs regarding json_table

2025-02-08 Thread Robert Treat
On Fri, Feb 7, 2025 at 11:56 AM Miłosz Chmura wrote: > > > > On Thu, Feb 6, 2025 at 10:22 PM Robert Treat wrote: > > On Wed, Feb 5, 2025 at 5:11 AM PG Doc comments form > > wrote: > > > > > > The following documentation comment has been logged on the website: > > > > > > Page: https://www.postgr

Re: Minor suggestions for docs regarding json_table

2025-02-07 Thread Miłosz Chmura
On Thu, Feb 6, 2025 at 10:22 PM Robert Treat wrote: > > On Wed, Feb 5, 2025 at 5:11 AM PG Doc comments form > wrote: > > > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/17/functions-json.html > > Description: > > > > In > > htt

Re: Minor suggestions for docs regarding json_table

2025-02-06 Thread Robert Treat
On Wed, Feb 5, 2025 at 5:11 AM PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/17/functions-json.html > Description: > > In > https://www.postgresql.org/docs/current/functions-json.html#FUNCTIONS-SQLJSON-

Minor suggestions for docs regarding json_table

2025-02-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/functions-json.html Description: In https://www.postgresql.org/docs/current/functions-json.html#FUNCTIONS-SQLJSON-TABLE 1. There is unused `PASSING` argument `filter2` Consider: ```sql S