haskell-beam / haskell-beam/beam

Possible to use aggregates over nullable columns?

Open
#86 1 comment 0 reactions 0 assignees View on GitHub
bug
Dominant language
Haskell
Stars
635
Forks
193
PR merge metrics
No merged PRs in 30d

Description

Is it possible to use aggregates directly over nullable columns? Of course one can manage by filtering and coalescing, but this seems like an unnecessary complication. In particular, it's easy to get `avg_` wrong when you coalesce *first* because each row will still count toward the average. Other aggregates like `sum_` don't have this danger.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.