From: | "Nathan Thatcher" <n8thatcher(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | GROUP BY hour |
Date: | 2008-08-01 17:55:02 |
Message-ID: | d9c17fb40808011055w750d6634ga5d6fca6b868fa25@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have, what I imagine to be, a fairly simple question. I have a query
that produces output for a line graph. Each row represents an interval
on the graph.
SELECT COUNT(call_id) AS value, EXTRACT(hour from start_time) AS hour
FROM c_call WHERE start_time >= '2008-08-01 00:00:00' AND end_time <=
'2008-08-01 23:59:59' GROUP BY hour
This works great when there is data in each interval but when a given
interval has no data the group is omitted. What is the best way to
ensure that the result contains a row for each interval with the value
field set to zero or null? The reporting tool is incapable of filling
in the gaps.
Thanks
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Crawford | 2008-08-01 18:18:10 | Re: GROUP BY hour |
Previous Message | EXT-Rothermel, Peter M | 2008-08-01 17:02:04 | Savepoints and SELECT FOR UPDATE in 8.2 |