X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 213CBD1CAA7 for ; Thu, 20 May 2004 18:45:41 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 37755-04 for ; Thu, 20 May 2004 18:45:23 -0300 (ADT) Received: from conexa.fciencias.unam.mx (conexa.fciencias.unam.mx [132.248.181.120]) by svr1.postgresql.org (Postfix) with ESMTP id C8506D1C4DB for ; Thu, 20 May 2004 18:45:19 -0300 (ADT) Received: from conexa.fciencias.unam.mx (conexa.fciencias.unam.mx [127.0.0.1]) by conexa.fciencias.unam.mx (8.12.8/8.12.8) with ESMTP id i4KLhcqJ008226; Thu, 20 May 2004 16:43:38 -0500 Received: (from masm@localhost) by conexa.fciencias.unam.mx (8.12.8/8.12.8/Submit) id i4KLhcTZ008224; Thu, 20 May 2004 16:43:38 -0500 X-Authentication-Warning: conexa.fciencias.unam.mx: masm set sender to masm@fciencias.unam.mx using -f To: Tom Lane Cc: pgsql-sql@postgresql.org Subject: Re: Simple view confuses PostgreSQL query planning References: <3948.1085079983@sss.pgh.pa.us> In-Reply-To: <3948.1085079983@sss.pgh.pa.us> From: Manuel Sugawara User-Name: Manuel Sugawara User-Mail-Address: masm@fciencias.unam.mx Date: 20 May 2004 16:43:38 -0500 Message-ID: Lines: 9 User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.4 (Portable Code) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_RFCI X-Spam-Level: X-Archive-Number: 200405/184 X-Sequence-Number: 17898 Tom Lane writes: > Get rid of the CASEs (perhaps you could wrap them into functions > declared STRICT) and the view would be flattenable. Will do that. Thanks. Regards, Manuel.