Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL question - problem with INTERSECT - Mailing list pgsql-general

From Tom Lane
Subject Re: SQL question - problem with INTERSECT
Date
Msg-id 24799.973155949@sss.pgh.pa.us
Whole thread Raw
In response to SQL question - problem with INTERSECT  ("Keith L. Musser" <kmusser@idisys.com>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Two Postmasters on the Same Machine
Next
From: Tom Lane
Date:
Subject: Re: NOTICE: Unrecognized variable query_limit