COUNT doesn't shows items with 0 occurrance

Поиск
Список
Период
Сортировка
От Giorgio A.
Тема COUNT doesn't shows items with 0 occurrance
Дата
Msg-id 001901c10ed1$5adfba90$3302a8c0@ducale.mentelocale.bogus
обсуждение исходный текст
Ответ на execute sql in a function?  ("Jiri D. Hoogeveen" <jiri@pro.nl>)
Ответы RE: COUNT doesn't shows items with 0 occurrance  ("Robby Slaughter" <webmaster@robbyslaughter.com>)
Список pgsql-novice
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 по дате отправления:

Предыдущее
От: "Todd T. Fries"
Дата:
Сообщение: Re: Serial field
Следующее
От: Virginie Garcia
Дата:
Сообщение: sequence primary key