Postgres Pro
Downloads
Home   >   mailing lists

Re: count(*) vs count(id) - Mailing list pgsql-general

From Matt Zagrabelny
Subject Re: count(*) vs count(id)
Date
Msg-id CAOLfK3W99Cdf9Sq+XyJv5MAjp9wsYBKpAC2UAVp7+dB881KmjQ@mail.gmail.com
Whole thread Raw
In response to Re: count(*) vs count(id)  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: count(*) vs count(id)
List pgsql-general
Tree view


On Mon, Feb 1, 2021 at 5:57 PM Rob Sargent <robjsargent@gmail.com> wrote:

[...]
 

You got one null from count(*) likely.

What is count(*) counting then? I thought it was rows.

-m

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: count(*) vs count(id)
Next
From: Tom Lane
Date:
Subject: Re: count(*) vs count(id)