"Marcus Torres" <marcsf23@yahoo.com> 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 output is incorrect.
If you think there's really a bug here, we need a *self contained*
test case.
regards, tom lane