Re: Bug #470: INTERSECT fails - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #470: INTERSECT fails
Date
Msg-id 16598.1001601318@sss.pgh.pa.us
Whole thread Raw
In response to Bug #470: INTERSECT fails  (pgsql-bugs@postgresql.org)
List pgsql-bugs
pgsql-bugs@postgresql.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

pgsql-bugs by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: [HACKERS] PostgreSQL / PHP Overrun Error
Next
From: Tom Lane
Date:
Subject: Re: maybe a bug?