sumit <sumit(at)gdit(dot)iiit(dot)net> writes:
> Thanks for letting know. Could you also let me know the exact
> syntax, I mean, we are not sure whether GROUP BY CUBE(...) is followed by
> a HAVING clause.
Better look at the SQL99 spec for yourself. There's a link to a draft
version in our developer's FAQ, IIRC.
regards, tom lane