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) a
On 10/11/05 8:50 AM, "Rick Schumeyer" <[EMAIL PROTECTED]> wrote:
> 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 ord
"Rick Schumeyer" <[EMAIL PROTECTED]> writes:
> 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".
Actually, referring to any of the output columns in any of the modifier
clau
Hi
Logically HAVING is executed after the GROUP BY and it must contain only the columns in the GROUP BY or aggregated function.
select state, count(state) as c from t group by state having c > 5
The above query grouped only on state and HAVING can be used only with the column state or the
