Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A2B85475AD7 for ; Tue, 19 Nov 2002 17:56:52 -0500 (EST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 6BFD64753A1 for ; Tue, 19 Nov 2002 17:56:51 -0500 (EST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 5AC00D612; Tue, 19 Nov 2002 14:56:50 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 507625C02; Tue, 19 Nov 2002 14:56:50 -0800 (PST) Date: Tue, 19 Nov 2002 14:56:50 -0800 (PST) From: Stephan Szabo To: Chris Gamache Cc: Subject: Re: Using VIEW to simplify code... In-Reply-To: <20021119213705.26206.qmail@web13808.mail.yahoo.com> Message-ID: <20021119145457.Y71165-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/287 X-Sequence-Number: 10429 On Tue, 19 Nov 2002, Chris Gamache wrote: > > If you want help, you must provide details. The PG version number is > > relevant also. > > Understood. PostgreSQL 7.2.3. 7.3 will be better for this. There were questions about the safety of pushing clauses down in queries with union and intersect and earlier versions wouldn't push down because we weren't sure it was safe. Except will still be problematic, but union and intersect should be much happier.