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
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) |