New posts in Aggregate

How to create aggregate function, like sum, with an implicit DISTINCT?

GROUP BY gives wrong result with MIN() aggregate function

Why is array_agg() slower than the non-aggregate ARRAY() constructor?

Median with GROUP BY

Why does COUNT() aggregate return 0 for 'NULL'?

Average of last 4 runs of a product

Calculate rolling sum over 7 consecutive day period on PostgreSQL

How can I pass column to function in sql?

Array integer[]: how to get all distinct values in a table and count them?

Efficient merging (removing duplicates) of arrays