X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 847E754EBF for ; Sat, 12 Mar 2005 19:18:28 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 21980-02 for ; Sat, 12 Mar 2005 19:18:26 +0000 (GMT) Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3473C54E1E for ; Sat, 12 Mar 2005 19:18:26 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id D9B653198E; Sat, 12 Mar 2005 20:18:26 +0100 (MET) From: Andrew - Supernews X-Newsgroups: pgsql.sql Subject: Re: Parameterized views proposition Date: Sat, 12 Mar 2005 19:18:25 -0000 Organization: http://www.supernews.com - all your nntp are belong to us Message-ID: References: <20050312163457.GC22317@wolff.to> Reply-To: andrew@supernews.com User-Agent: slrn/0.9.8.0 (FreeBSD) X-Complaints-To: abuse@supernews.com Lines: 11 To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/171 X-Sequence-Number: 20650 On 2005-03-12, Bruno Wolff III wrote: > You need to expose the columns you want to filter on so that they can > be used in WHERE clauses. That doesn't help when you're doing outer joins with additional join restrictions; the semantics of those can't be converted into additional WHERE clauses. -- Andrew, Supernews http://www.supernews.com - individual and corporate NNTP services