Re: SQL question - problem with INTERSECT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Keith L(dot) Musser" <kmusser(at)idisys(dot)com>
Cc: "PGSQL-General" <pgsql-general(at)postgresql(dot)org>, "Dave Trepanier" <be164(at)yahoo(dot)com>
Subject: Re: SQL question - problem with INTERSECT
Date: 2000-11-02 09:05:49
Message-ID: 24799.973155949@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Keith L. Musser" <kmusser(at)idisys(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-11-02 09:17:03 Re: NOTICE: Unrecognized variable query_limit
Previous Message Tom Lane 2000-11-02 08:41:27 Re: Two Postmasters on the Same Machine