"Keith L. Musser" <kmusser@idisys.com> writes:
> PGSQL doesn't accept the combination. It gives me this error message:
> "SELECT / HAVING requires aggregates to be valid".
What PG version are you running? AFAICT this works in 7.0.2, but
I wouldn't be too surprised that you might see a failure like that
in 6.5 or before.
regards, tom lane