problem in sql - sum() - Mailing list pgsql-bugs

From ivan@adicional.com.br
Subject problem in sql - sum()
Date
Msg-id 206706195.1632677.1458657729534.JavaMail.zimbra@adicional.com.br
Whole thread Raw
Responses Re: problem in sql - sum()  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: problem in sql - sum()  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-bugs
Hi. I have a problem identified.
In select :

select data_carteira, sum(valor_carteira) from carteira where
data_carteira between '2016-01-01' and '2016-02-18'
GROUP BY data_carteira order by data_carteira

return a values from month. In the day 18, return the value 82.915.213,14.

Now, if I use the select :
select data_carteira, sum(valor_carteira) from carteira where
data_carteira=3D'2016-01-18'
GROUP BY data_carteira order by data_carteira

return 103.629.305,96.

It's very diferenty.
Only change is date.

The version in use is :
PostgreSQL 9.0.8 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.6.=
3 20120306 (Red Hat 4.6.3-2), 64-bit

Please, helpe me.

Thanks,

Ivan Rodrigues
Brazil - S=C3=A3o Paulo

pgsql-bugs by date:

Previous
From: Reece Pegues
Date:
Subject: Re: BUG #14038: substring cuts unicode char in half, allowing to save broken utf8 into table
Next
From: "David G. Johnston"
Date:
Subject: Re: problem in sql - sum()