Re: [SQL] Re: sum gives different answer

From: Clark Evans <clark(dot)evans(at)manhattanproject(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)hub(dot)org
Subject: Re: [SQL] Re: sum gives different answer
Date: 1999-03-14 18:10:11
Message-ID: 36EBFB83.F425A2FE@manhattanproject.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Chairudin Sentosa <chairudin(at)prima(dot)net(dot)id> 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Vikrant Rathore 1999-03-15 09:19:44 Mail about FOREIGN KEY
Previous Message Tom Lane 1999-03-14 18:04:27 Re: sum gives different answer