PG Doc comments form writes:
> Near the end of Chapter 2.7 Aggregate Functions of the documentation, the
> command FILTER is introduced. The full query is
> SELECT city, max(temp_lo), count(*) FILTER (WHERE temp_lo < 30)
> FROM weather
> GROUP BY city
> HAVING max(temp_lo) < 40;
> an
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/15/tutorial-agg.html
Description:
Near the end of Chapter 2.7 Aggregate Functions of the documentation, the
command FILTER is introduced. The full query is
SELECT city, max(temp_lo), count(*