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