Re: count(*) vs count(id)

["aNullValue (Drew Stemen)" <drew@xxxxxxxxxxxxxx>]

At 2021-02-01T20:14:04-05:00, Matt Zagrabelny <mzagrabe@xxxxxxxxx> 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).