From: | Chairudin Sentosa <chairudin(at)prima(dot)net(dot)id> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | sum gives different answer |
Date: | 1999-03-12 12:24:12 |
Message-ID: | 36E9076C.2850C00@prima.net.id |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi all,
I have two SQL statements that I expect to give (0 rows) as output.
However the first one with 'sum' does not do that.
Why the first SQL statement gives (1 row) and empty?
While the second SQL statement can give (0 row).
I am using postgresql 6.4.2.
First
------
select pin, sum(duration) from tablename where date(start_time)=
(select date 'today') group by pin;
pin|sum
---+---
|
(1 row)
Second
------
select pin, duration from tablename where date(start_time)=
(select date 'today') group by pin;
pin|duration
---+--------
(0 rows)
Could anyone tell me why, please?
Regards
Chai
From | Date | Subject | |
---|---|---|---|
Next Message | ZioBudda | 1999-03-12 13:03:38 | where can I get... |
Previous Message | Chairudin Sentosa | 1999-03-12 11:28:41 | sum gives different answer |