[BUGS] BUG #3914: Self-Join Group-By Clause Produces Incorrect Results

2008-01-30 Thread Marcus Torres
The following bug has been logged online: Bug reference: 3914 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: I wrote a

Re: [BUGS] BUG #3914: Self-Join Group-By Clause Produces Incorrect Results

2008-01-30 Thread Tom Lane
Marcus Torres [EMAIL PROTECTED] writes: I wrote a simply 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 highly incorrect. You have provided no evidence whatsoever that this