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

2008-02-14 Thread Marc SanF
arcus Torres <[EMAIL PROTECTED]>; pgsql-bugs@postgresql.org Sent: Wednesday, February 13, 2008 7:40:32 AM Subject: Re: [BUGS] BUG #3958: Self-Join Group-By Clause Produces Incorrect Results "Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > Marcus Torres wrote: >>

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

2008-02-14 Thread Marc SanF
ebruary 13, 2008 7:40:32 AM Subject: Re: [BUGS] BUG #3958: Self-Join Group-By Clause Produces Incorrect Results "Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > Marcus Torres wrote: >> I wrote a simple self-join query to sum the transaction count

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

2008-02-13 Thread Tom Lane
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > Marcus Torres wrote: >> 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

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

2008-02-13 Thread Heikki Linnakangas
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 Det

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

2008-02-13 Thread Marcus Torres
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 repo