Matt Zagrabelny <[email protected]> writes: > On Mon, Feb 1, 2021 at 5:57 PM Rob Sargent <[email protected]> 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
