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 1A20253924 for ; Tue, 29 Mar 2005 17:03:39 +0100 (BST) 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 98063-02 for ; Tue, 29 Mar 2005 16:03:36 +0000 (GMT) Received: from web1-glo.biscit.net (web1-glo.biscit.net [82.195.96.53]) by svr1.postgresql.org (Postfix) with ESMTP id 3F61A5393A for ; Tue, 29 Mar 2005 17:03:33 +0100 (BST) Received: from bolek.coachhouse (host62-6-126-83.webport.bt.net [62.6.126.83]) by web1-glo.biscit.net (8.10.2/8.10.2) with ESMTP id j2TG3OA18106; Tue, 29 Mar 2005 17:03:24 +0100 Received: (Exim 3.36) #1 (Debian)) protocol: esmtp id 1DGJA9-00025J-00 ; Tue, 29 Mar 2005 17:01:53 +0100 Message-ID: <42497BF1.7030405@numerixtechnology.de> Date: Tue, 29 Mar 2005 17:01:53 +0100 From: T E Schmitz Reply-To: mailreg@numerixtechnology.de User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Bruno Wolff III Cc: Scott Marlowe , pgsql-sql@postgresql.org Subject: Re: cost of CREATE VIEW ... AS SELECT DISTINCT References: <42487A6D.6020506@numerixtechnology.de> <1112047463.22988.25.camel@state.g2switchworks.com> <424928D8.7060705@numerixtechnology.de> <20050329132941.GA27251@wolff.to> <4249564B.1000807@numerixtechnology.de> <20050329150418.GA32031@wolff.to> In-Reply-To: <20050329150418.GA32031@wolff.to> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.066 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/382 X-Sequence-Number: 20861 Bruno Wolff III wrote: > On Tue, Mar 29, 2005 at 14:21:15 +0100, > T E Schmitz wrote: >>If that's the case, I should come up with a different concept to obtain >>a list of ORIGINs. > > > That may be a good idea, especially if there are lots of rows for each > origin value. That's what I will do. Thank you for all your input. -- Regards/Gruß, Tarlika Elisabeth Schmitz