| 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: | Whole Thread | Raw Message | 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
| 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 |