Counting comments

Christopher Hicks chicks at
Sat Oct 16 15:45:39 UTC 2004

On Sat, 16 Oct 2004, Gervase Markham wrote:
> Is it possible, either via the GUI or directly in SQL, to say:
> "Give me a list of all bugs meeting certain criteria, which in addition
> have (exactly 1|more than 1) comment"?
> I can do:
> SELECT bug_id, count(bug_when) AS bug_count FROM longdescs GROUP BY bug_id;
> but then I can't say "AND bug_count > 1" - it doesn't like that.
> At a pinch, I could cope with a solution just for one of the two cases,
> as I could do the root query and subtract.

Isn't that what HAVING is for?


"Documentation is like sex: when it is good, it is very, very good;
and when it is bad, it is better than nothing."  -- Dick Brandon

More information about the developers mailing list