Received: from monster.clarkevans.com (IDENT:root@pool-209-138-192-156.nwrk.grid.net [209.138.192.156]) by hub.org (8.9.2/8.9.1) with ESMTP id NAA17181 for ; Sun, 14 Mar 1999 13:14:21 -0500 (EST) (envelope-from clark.evans@manhattanproject.com) Received: from manhattanproject.com (clark@localhost [127.0.0.1]) by monster.clarkevans.com (8.8.7/8.8.7) with ESMTP id NAA00812; Sun, 14 Mar 1999 13:10:11 -0500 Sender: clark@monster.clarkevans.com Message-ID: <36EBFB83.F425A2FE@manhattanproject.com> Date: Sun, 14 Mar 1999 18:10:11 +0000 From: Clark Evans X-Mailer: Mozilla 4.5 [en] (X11; U; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane CC: pgsql-sql@hub.org Subject: Re: [SQL] Re: sum gives different answer References: <29740.921434667@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Chairudin Sentosa writes: > select pin, sum(duration) from tablename where date(start_time)= > (select date 'today') group by pin; > pin|sum > - ---+--- > | > (1 row) Definately a bug. Tom Lane wrote: > SUM() should never have been applied at all Yep. Clark Evans