problem in sql - sum()

Поиск
Список
Период
Сортировка
От ivan@adicional.com.br
Тема problem in sql - sum()
Дата
Msg-id 206706195.1632677.1458657729534.JavaMail.zimbra@adicional.com.br
обсуждение исходный текст
Ответы Re: problem in sql - sum()  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: problem in sql - sum()  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Reece Pegues
Дата:
Сообщение: Re: BUG #14038: substring cuts unicode char in half, allowing to save broken utf8 into table
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: problem in sql - sum()