Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D2ED2476F4C for ; Wed, 8 Jan 2003 11:14:54 -0500 (EST) Received: from benhur.intern.control.de (unknown [217.89.112.10]) by postgresql.org (Postfix) with ESMTP id 2D19F4763D8 for ; Wed, 8 Jan 2003 11:14:15 -0500 (EST) Received: from devserver (devserver.intern.control.de [192.168.100.5]) by benhur.intern.control.de (8.12.6/8.12.6/Benhur 8.12.6) with ESMTP id h08GDVVO030991; Wed, 8 Jan 2003 17:13:32 +0100 Content-Type: text/plain; charset="iso-8859-1" From: Boris Klug Organization: control IT GmbH To: "Michael Paesold" , "Tomasz Myrta" , "Hannu Krosing" Subject: Re: Unions and where optimisation Date: Wed, 8 Jan 2003 17:13:00 +0100 User-Agent: KMail/1.4.3 Cc: References: <200301081425.48597.boris.klug@control.de> <200301081536.33211.boris.klug@control.de> <013001c2b72d$658ee4b0$3201a8c0@beeblebrox> In-Reply-To: <013001c2b72d$658ee4b0$3201a8c0@beeblebrox> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200301081713.00786.boris.klug@control.de> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/61 X-Sequence-Number: 708 Hello! > As far as I know, this has first been "fixed" in 7.3. I think it was Tom > who improved the optimizer to push the where clause into the selects of a > union view. I've done a test... Yes, I installed 7.3 and it works fine there. I think we will upgrade to 7.= 3.1=20 our development system soon. Thank you! --=20 Dipl. Inform. Boris Klug, control IT GmbH, Germany