Matt Zagrabelny <mzagr...@d.umn.edu> writes: > On Mon, Feb 1, 2021 at 5:57 PM Rob Sargent <robjsarg...@gmail.com> wrote: >> You got one null from count(*) likely.
> What is count(*) counting then? I thought it was rows. Yeah, but count(id) only counts rows where id isn't null. regards, tom lane