problem in sql - sum()

From: ivan(at)adicional(dot)com(dot)br
To: pgsql-bugs(at)postgresql(dot)org
Subject: problem in sql - sum()
Date: 2016-03-22 14:42:09
Message-ID: 206706195.1632677.1458657729534.JavaMail.zimbra@adicional.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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='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ão Paulo

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message xenophon 2016-03-22 18:28:31 BUG #14040: Cannot authenticate against Active Directory in search+bind mode using domain root naming context
Previous Message Peter Geoghegan 2016-03-22 07:53:31 Re: Missing rows with index scan when collation is not "C" (PostgreSQL 9.5)