OK, thanks. That seems to make sense.
regards
Iain
----- Original Message -----
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Iain" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, December 02, 2004 11:54 AM
Subject: Re: [SQL] invalid 'having' clause
> "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]
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
