"Iain" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
