Re: problem in sql - sum()

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: ivan(at)adicional(dot)com(dot)br, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: problem in sql - sum()
Date: 2016-03-22 21:07:56
Message-ID: 20160322210756.GA518456@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

David G. Johnston wrote:

> The OP claims that the corresponding rows don't match but I personally have
> not excluded user error - specifically that my assumption (above) of what
> is being compared matches that which is actually being compared.
>
> I'm also not that inclined to debug 9.0.8 when the entire 9.0 release is
> out of support and there are 13 point releases - any of which might have
> been required to fix a bug that exhibits this behavior.

I misspoke. My intention here was to point out that this is most likely
user error, not a software bug, despite how obsolete the version. Yes,
he needs to upgrade, but I cannot honestly believe that upgrading would
"solve" this particular problem.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Geoghegan 2016-03-22 21:09:52 Re: Missing rows with index scan when collation is not "C" (PostgreSQL 9.5)
Previous Message David G. Johnston 2016-03-22 21:00:46 Re: problem in sql - sum()