The Hermit Hacker <[EMAIL PROTECTED]> writes:
>> So that inflates the number of rows coming out of the join by 5.
> Okay, then I'm lost ... why wouldn't that show up without the COUNT()? I
> doubt doubt your analysis, I just want to understand why ...
You had DISTINCT on your query, which hid the duplicated rows from you.
But that happens *after* aggregate processing, so it doesn't hide the
dups from COUNT().
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
