On Mon, Feb 1, 2021 at 7:19 PM Guillaume Lelarge <guilla...@lelarge.info> wrote:
> > > You're doing a left join, so I guess there's no row where > call_records.timestamp::date = 2020-08-30. That would result with a NULL id. > > Thanks for the excellent analysis everyone. I appreciate it! Here is the documentation (for anyone reading the mailing list in the future...) count(*) bigint number of input rows count(expression) any bigint number of input rows for which the value of expression is not null Have a great night (or equivalent for your TZ). -m
