Changes between Version 1 and Version 2 of Ticket #36638, comment 5
- Timestamp:
- Oct 3, 2025, 12:43:16 PM (2 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #36638, comment 5
v1 v2 11 11 > It should be noted that except for `count`, these functions return a null value when no rows are selected. In particular, `sum` of no rows returns null, not zero as one might expect, and `array_agg` returns null rather than an empty array when there are no input rows. The `coalesce` function can be used to substitute zero or an empty array for null when necessary. 12 12 13 Concretely this means that `Aggregate .default` is a nicer way to express `Coalesce(Aggregate(...), default)`.13 Concretely this means that `Aggregate(default)` is a nicer way to express `Coalesce(Aggregate(...), default)`.