Re: Ltree pattern matching

2021-11-12 Thread Tom Lane
PG Doc comments form writes: > In v12 ltree doc (I've not checked other versions) > "The behavior of % is a bit complicated. It tries to match words rather than > the entire label. For example foo_bar% matches foo_bar_baz but not > foo_barbaz. If combined with *, prefix matching applies to each wo

Re: Example of json_array_elements

2021-11-12 Thread Daniel Gustafsson
> On 12 Nov 2021, at 13:18, PG Doc comments form wrote: > Maybe this example for json_array_elements is wrong? No, the example works as intended and yields the output in the documentation: postgres=# select * from json_array_elements('[1,true, [2,false]]'); value --- 1 true [2,fal

Re: \dp privileges "decoder" dropped in v12 of docs

2021-11-12 Thread Bruce Momjian
On Thu, Nov 11, 2021 at 09:24:21PM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/sql-grant.html > Description: > > Hello, I'm wondering why this version of the GRANT doc has the \dp privilege >

Example of json_array_elements

2021-11-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/functions-json.html Description: Maybe this example for json_array_elements is wrong? select * from json_array_elements('[1,true, [2,false]]') It seems to me that it should be select *

Ltree pattern matching

2021-11-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/ltree.html Description: In v12 ltree doc (I've not checked other versions) "The behavior of % is a bit complicated. It tries to match words rather than the entire label. For example foo_ba

RE: text fields and performance for ETL

2021-11-12 Thread Grega Jesih
Dear Moderators, with this approach, why don't you eliminate char and varchar then ? Thanks for thinking over. BR Grega -Original Message- From: Laurenz Albe Sent: Saturday, November 6, 2021 6:28 AM To: Bruce Momjian ; David G. Johnston Cc: Grega Jesih ; Tom Lane ; Pg Docs Subject:

\dp privileges "decoder" dropped in v12 of docs

2021-11-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-grant.html Description: Hello, I'm wondering why this version of the GRANT doc has the \dp privilege definitions - https://www.postgresql.org/docs/9.3/sql-grant.html - but it's no long

Re: Update documentation page for translators

2021-11-12 Thread Daniel Gustafsson
> On 22 Oct 2021, at 13:12, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/11/nls-translator.html > Description: > > In the documentation for translators > (https://www.postgresql.org/docs/11/nls-tran