Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Subject: 4.2.7. Aggregate Expressions
To: pgsql-docs@lists.postgresql.org
From: PG Doc comments form <noreply@postgresql.org>
Cc: y.saburov@gmail.com
Reply-To: y.saburov@gmail.com, pgsql-docs@lists.postgresql.org
Date: Thu, 27 Aug 2026 14:26:46 +0000
Message-ID: <178784080621.1060526.4544192651418189612@wrigleys.postgresql.org>
Auto-Submitted: auto-generated
Archived-At: 
 <https://www.postgresql.org/message-id/178784080621.1060526.4544192651418189612%40wrigleys.postgresql.org>
Precedence: bulk

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=3D# 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=E2=80=99t seen the term =E2=80=9Cf1=E2=80=9D before=E2=80=94and th=
e paragraph doesn=E2=80=99t specify that
this is a field.