At 2021-02-01T20:14:04-05:00, Matt Zagrabelny <mzagr...@d.umn.edu> sent:
> select count(id) from call_records where id is null;
>  count 
> ═══════
>      0
> (1 row)
> 
> Time: 0.673 ms
> 
> Which field is count(*) counting if it is counting nulls?
> 
> -m

What you're overlooking is that, at least to my reading of your original query, 
id would be null for any dates that do not have any corresponding call_records 
(because you used a left join). 

Reply via email to