Received: from ritig9.rit.reuters.com (ritig9.rit.reuters.com [199.171.195.8]) by hub.org (8.10.1/8.10.1) with ESMTP id e7HBxem98875 for ; Thu, 17 Aug 2000 07:59:40 -0400 (EDT) Message-Id: <200008171159.e7HBxem98875@hub.org> Date: Thu, 17 Aug 2000 13:55:19 +0200 From: Maarten Boekhold Subject: Re: car mileage summation / sledgehammer method To: Oliver Seidel Cc: pgsql-sql@hub.org, vpaul@dohle.com, xy0xy0@earthlink.net MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-disposition: inline X-Lotus-FromDomain: REUTERS X-Archive-Number: 200008/153 > View definition: SELECT mileage.miles, mileage.date FROM mileage; > detail=# select mileage.miles, mileage.date, sum(dup.miles) from > mileage, dup > where > dup.date <= mileage.date group by mileage.date, mileage.miles > order by mileage.date; Now that's a bit stupid. Why create this view when you can do the same thing with a table alias (I'm I calling this by the right name?). select m.miles, m.date, sum(d.miles) from mileage m, mileage d where....... Maarten ----------------------------------------------------------------- Visit our Internet site at http://www.reuters.com Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd.