Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group