Re: Typo in DATATYPE-JSONPATH

2021-04-15 Thread Michael Paquier
On Fri, Apr 16, 2021 at 08:11:53AM +0200, Erik Rijkers wrote: > FWIW, I agree with this and already sent a doc-patch [1], which is > be applied from 12, 13, and master. Arf. I completely forgot about this thread but I marked it as something to look at. Will do so now. -- Michael signature.asc

Re: Typo in DATATYPE-JSONPATH

2021-04-15 Thread Erik Rijkers
> On 2021.04.15. 22:04 PG Doc comments form wrote: > > Page: https://www.postgresql.org/docs/13/datatype-json.html > Description: > > Hello, > > On the DATATYPE-JSONPATH page: > https://www.postgresql.org/docs/13/datatype-json.html#DATATYPE-JSONPATH > > There is a line that shows that GIN ind

Re: INCLUDING COMPRESSION

2021-04-15 Thread Michael Paquier
On Thu, Apr 15, 2021 at 11:24:07PM +0900, Fujii Masao wrote: > I'm not sure why. But +1 to make them in alphabetical order. > Patch attached. LGTM. -- Michael signature.asc Description: PGP signature

Typo in DATATYPE-JSONPATH

2021-04-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/datatype-json.html Description: Hello, On the DATATYPE-JSONPATH page: https://www.postgresql.org/docs/13/datatype-json.html#DATATYPE-JSONPATH There is a line that shows that GIN indexes

Re: INCLUDING COMPRESSION

2021-04-15 Thread Fujii Masao
On 2021/04/15 11:54, Michael Paquier wrote: On Wed, Apr 14, 2021 at 11:46:58PM +0900, Fujii Masao wrote: The syntax for like_option in CREATE TABLE docs seems to forget to mention INCLUDING COMPRESSION option. I think the following fix is necessary. Patch attached. -{ INCLUDING | EXCLUDING }

Re: Typo in psql doc

2021-04-15 Thread Ludovic Kuty
Yes indeed, thanks. I re-tested the example this morning and it worked correctly with the space. I guess I had messed up things when I first tried it. Michael Paquier 14 April 2021 at 07:58 Both commands sey in your .psqlrc results in the same path being used, as I

Date/Time Functions and Operators

2021-04-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-datetime.html Description: Please also include some examples that extract few columns from some tables. For e.g. SELECT EXTRACT(YEAR FROM hire_date) FROM Employee WHERE id = 1234

Re: Typo in psql doc

2021-04-15 Thread Michael Paquier
On Thu, Apr 15, 2021 at 09:55:53AM +0200, Ludovic Kuty wrote: > Yes indeed, thanks. I re-tested the example this morning and it worked > correctly with the space. I guess I had messed up things when I first tried > it. After seeing Tom's argument that this behavior become more consistent in 9.2, a