Marcus Torres wrote:
The following bug has been logged online:
Bug reference: 3958
Logged by: Marcus Torres
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.19
Operating system: Linux - Ubuntu
Description: Self-Join Group-By Clause Produces Incorrect Results
Details:
This is a repost of my original bug with self-contained sql to reproduce the
problem:
I wrote a simple self-join query to sum the transaction count of different
types of records in a audit table and the result set for the different sum
totals was the same which is incorrect.
Looks perfectly correct to me.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
