[SQL] question re. count, group by, and having

[Rick Schumeyer]

The following query returns an error (“column c does not exist”) in pg 8.0.3:   (The column ‘state’ is the two letter abbreviation for a US state)   -- get the number of rows for each state; list in descending order; include only states with at least 6 rows select state, count(state) as c from t group by state having c > 5 order by c desc; -- gives error   If I leave the having clause out, I get the expected results:   select state, count(state) as c from t group by state order by c desc; -- this works   Is this a bug or a feature?  I’m not sure why I can use ‘c’ in the order by clause but not the having clause.  pg is much happier with the full “having count(state) > 5”.  Will this cause count to be evaluated twice?   If it matters, state is varchar(2).