Re: count(*) vs count(id)

From: Matt Zagrabelny <mzagrabe(at)d(dot)umn(dot)edu>
To: Rob Sargent <robjsargent(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: count(*) vs count(id)
Date: 2021-02-02 00:32:18
Message-ID: CAOLfK3W99Cdf9Sq+XyJv5MAjp9wsYBKpAC2UAVp7+dB881KmjQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 1, 2021 at 5:57 PM Rob Sargent <robjsargent(at)gmail(dot)com> wrote:

[...]

>
> You got one null from count(*) likely.
>

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

-m

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-02-02 00:34:58 Re: count(*) vs count(id)
Previous Message Rob Sargent 2021-02-01 23:55:05 Re: count(*) vs count(id)