PostgreSQL "nested"? distincts and count 
===

<h3>I need to get the count of the distinct names per hour in one query in PostgreSQL 9.1</h3>
The relevant columns(generalized for question) in my table are:

    occurred timestamp with time zone and
    name character varying(250) 
And the table name for the sake of the question is just `table`

The `occurred` timestamps will all be within a midnight to midnight(exclusive) range for one day. So far my query looks like:
    
    'SELECT COUNT(DISTINCT ON (name)) FROM table'
It would be nice if I could get the output formatted as a list 24 integers(one for each hour of the day), the names aren't required to be returned. 
