September 26, 2024: PostgreSQL 17 Released!

Feature Description

FILTER clause for aggregate functions

Aggregate functions can now be filtered with the FILTER clause. For example: count(col_a) FILTER (WHERE col_b > 5)