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

Re: Problems with select chaining using INTERSECT

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Michael Beckstette <mbeckste(at)TechFak(dot)Uni-Bielefeld(dot)DE>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Problems with select chaining using INTERSECT
Date: 2002-06-13 21:02:38
Message-ID: 20020613140127.Q7376-100000@megazone23.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Thu, 13 Jun 2002, Michael Beckstette wrote:

> Version: PostgreSQL 7.1.2 on sparc-sun-solaris2.5.1, compiled by GCC 2.95
>
> Hi, when using SELECT queries chained by INTERSECT i get confused about the
> behavour of the INTERSECT operation. I try to outline this with the following
> examples.

I don't remember exact details, but I believe there were bugs in the
intersect implementation of the past.  You might want to see if it works
on 7.2.x



In response to

pgsql-bugs by date

Next:From: Sam O'ConnorDate: 2002-06-14 01:44:18
Subject: pg_dump fails for views with UNION and SELECT DISTINCT
Previous:From: Tom LaneDate: 2002-06-13 20:41:13
Subject: Re: Problems with select chaining using INTERSECT

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