COUNT and GROUP BY performing strangely

From: James David Smith <james(dot)david(dot)smith(at)gmail(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: COUNT and GROUP BY performing strangely
Date: 2013-10-25 10:08:39
Message-ID: CAMu32AASscD4h6wQW6xO1thpuWfYpq3e1ML04-zZNksHykXsFg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi everyone,

Any thoughts on the below three queries please?

james_traffic=# SELECT count(*) FROM stage;
count
--------
430991
(1 row)

james_traffic=# SELECT bad_flag, count(bad_flag) FROM stage GROUP BY bad_flag;
bad_flag | count
----------+-------
| 0
1 | 4102
(2 rows)

james_traffic=# SELECT count(bad_flag) FROM stage;
count
-------
4102
(1 row)

I'm confused as to why the second query doesn't return this:

bad_flag | count
--------------+-------
| 426889
1 | 4102

It should count the records surely, even if the field is blank/null ?

Thanks

James

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Thomas Kellerer 2013-10-25 10:26:41 Re: COUNT and GROUP BY performing strangely
Previous Message Luca Ferrari 2013-10-21 16:05:22 Re: Using index name in select Query