Re: description of Aggregate Expressions

John Lumby wrote: < < Tom Lane wrote < < > > How about replacing "expression [ , ... ]" by "parameter_list" in the description, < > > and then stating that parameter_list can be either a single expression or , < > > if the particular aggregate function accepts it (for which, consult tha

Re: description of Aggregate Expressions

Tom Lane wrote > > How about replacing "expression [ , ... ]"  by "parameter_list" in the > > description, > > and then stating that parameter_list can be either a single expression or , > >  if the particular aggregate function accepts it (for which,   consult that > > function's reference),

Re: description of Aggregate Expressions

John Lumby writes: > On 12/05/19 18:06, David G. Johnston wrote: >> Then I would have to say the proposed solution to this edge case is worse >> than the problem. I also don't expect there to be a clean solution to >> dealing with the complexities of expressions at the syntax diagram level. >

Re: description of Aggregate Expressions

On 12/05/19 18:06, David G. Johnston wrote: On Thu, Dec 5, 2019 at 3:18 PM John Lumby <johnlu...@hotmail.com> wrote: In PostgreSQL 12.1 Documentation chapter 4.2.7. Aggregate Expressions it says The syntax of an aggregate expression i

Re: Description of Authentication Methods Supported for Map is Misleading

On Fri, Dec 6, 2019 at 10:13 AM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/10/auth-pg-hba-conf.html > Description: > > "This option is supported for all authentication methods that receive > external

It is recommended to add detailed description about initdb ...

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/creating-cluster.html Description: When I run initdb -D /home/myname/pgsql/data in /home/myname/pgsql/bin, it return bash: initdb: command not found The others are like this. It must b

Description of Authentication Methods Supported for Map is Misleading

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/auth-pg-hba-conf.html Description: "This option is supported for all authentication methods that receive external user names." More properly, the authentication methods supported are: id

Re: monitoring-stats.html is too impenetrable

Thanks, Michael, but I am absolutely convinced that whether a needed index exists or not is absolutely one of the most run-time consequential inputs to the query planner. Also, that page is where people look to optimize, unlike the impenetrable wall-of-text stats page. Please correct me if I am wro

Difference between Bulk Load (Multiple inserts or single inserts) and COPY

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/sql-copy.html Description: Hello, > I experimented with Bulk load and COPY. > Loading in COPY was very fast. > However, after COPYing data from a CSV file to PostgreSQL Table. The query >