Search Postgresql Archives
Re: count(*) vs count(id)
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: count(*) vs count(id)
From
: Matt Zagrabelny <mzagrabe@xxxxxxxxx>
Date
: Mon, 1 Feb 2021 18:32:18 -0600
Cc
: "pgsql-generallists.postgresql.org" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to
: <
cb465259-e29a-8fc2-1890-2666b8d79f36@gmail.com
>
References
: <CAOLfK3VWa_Mv3OSumvpHZdppd+qDj8EUWCdxY5+vUe=gAo+h0A@mail.gmail.com> <
cb465259-e29a-8fc2-1890-2666b8d79f36@gmail.com
>
On Mon, Feb 1, 2021 at 5:57 PM Rob Sargent <
robjsargent@xxxxxxxxx
> wrote:
[...]
You got one null from count(*) likely.
What is count(*) counting then? I thought it was rows.
-m
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: count(*) vs count(id)
From:
Tom Lane
References
:
count(*) vs count(id)
From:
Matt Zagrabelny
Re: count(*) vs count(id)
From:
Rob Sargent
Prev by Date:
Re: count(*) vs count(id)
Next by Date:
Re: count(*) vs count(id)
Previous by thread:
Re: count(*) vs count(id)
Next by thread:
Re: count(*) vs count(id)
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
