[SQL] invalid 'having' clause

[Iain]

Hi,

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

This isn't valid in pg (7.4.6), but this is:

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

Does anyone have any idea?

I can't remember what other databases do, and I'm not so familiar with the 
standards, but I just thought I'd mention it anyway.

regards
Iain 


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org