Re: Bug #470: INTERSECT fails

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: vincze(at)neb(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #470: INTERSECT fails
Date: 2001-09-27 14:35:18
Message-ID: 16598.1001601318@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)org writes:
> INTERSECT fails

I believe this is fixed in current sources (7.2-to-be). The problem
is with INTERSECT (or EXCEPT) as the input to another INTERSECT/EXCEPT.
You could work around it in 7.1 by doing one INTERSECT into a temp
table and then intersecting with that.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-09-27 14:49:37 Re: maybe a bug?
Previous Message pgsql-bugs 2001-09-27 14:29:45 Bug #471: [make install] problem with jdbc driver in 7.1.3