↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Feature: 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)