From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: y.saburov@gmail.com
Subject: 4.2.7. Aggregate Expressions
Date: Thu, 27 Aug 2026 14:26:46 +0000
Message-ID: <178784080621.1060526.4544192651418189612@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/18/sql-expressions.html
Description:
Can you add a code block with an example?
Perhaps something like this:
```psql
db=# WITH vals (f1) AS ( VALUES (1),(3),(4),(3),(2),(null) )
SELECT count(*), count(f1), COUNT(DISTINCT f1) FROM vals;
count | count | count
-------+-------+-------
6 | 5 | 4
(1 row)
```
After:
>> For example, count(*) returns the total number of input rows; count(f1)
returns the number of input rows in which f1 is not null, since count
ignores null values; and count(distinct f1) returns the number of distinct
non-null values of f1.
We haven’t seen the term “f1” before—and the paragraph doesn’t specify that
this is a field.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, y.saburov@gmail.com
Subject: Re: 4.2.7. Aggregate Expressions
In-Reply-To: <178784080621.1060526.4544192651418189612@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox