Re: invalid 'having' clause

"Iain" <iain@mst.co.jp> writes:
> Just a quick question out of curiosity, I was just wondering if this is 
> supposed to be valid sql:

> select count(*) as cnt
> from sometable
> group by somecolumn
> having cnt > 1

No.  The HAVING clause logically executes before the SELECT output list
does, so it makes no sense for it to refer to the output list entries.
        regards, tom lane