]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Doc: improve tutorial section about grouped aggregates.
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 8 Nov 2022 23:25:03 +0000 (18:25 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 8 Nov 2022 23:25:03 +0000 (18:25 -0500)
commit362ba3e932c0f343a199b74f94ca7b22f4f8448d
tree7c21e1b6de046b6c67d37d1ccd2688a0931e731b
parentc5dc80c1bc216f0e21a2f79f5e0415c2d4cfb35d
Doc: improve tutorial section about grouped aggregates.

Commit fede15417 introduced FILTER by jamming it into the existing
example introducing HAVING, which seems pedagogically poor to me;
and it added no information about what the keyword actually does.
Not to mention that the claimed output didn't match the sample
data being used in this running example.

Revert that and instead make an independent example using FILTER.
To help drive home the point that it's a per-aggregate filter,
we need to use two aggregates not just one; for consistency
expand all the examples in this segment to do that.

Also adjust the example using WHERE ... LIKE so that it'd produce
nonempty output with this sample data, and show that output.

Back-patch, as the previous patch was.  (Sadly, v10 is now out
of scope.)

Discussion: https://postgr.es/m/166794307526.652.9073408178177444190@wrigleys.postgresql.org
doc/src/sgml/query.sgml