Postgres Pro
Downloads
Home   >   mailing lists

COUNT doesn't shows items with 0 occurrance - Mailing list pgsql-novice

From Giorgio A.
Subject COUNT doesn't shows items with 0 occurrance
Date
Msg-id 001901c10ed1$5adfba90$3302a8c0@ducale.mentelocale.bogus
Whole thread Raw
In response to execute sql in a function?  ("Jiri D. Hoogeveen" <jiri@pro.nl>)
Responses RE: COUNT doesn't shows items with 0 occurrance  ("Robby Slaughter" <webmaster@robbyslaughter.com>)
List pgsql-novice
Tree view 
hi all,
i have this little problem: when i do a

SELECT COUNT (*) AS number, pieces
FROM hardware
GROUP BY pieces

if a pieces has 'number = 0' it's not shown in the result report ... how can
i fix this, having as a result the whole list of my hardware pieces ?

tnx !

have a nice day

Giorgio A.

pgsql-novice by date:

Previous
From: "Todd T. Fries"
Date:
Subject: Re: Serial field
Next
From: Virginie Garcia
Date:
Subject: sequence primary key