Re: bug in JOIN or COUNT or ... ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: bug in JOIN or COUNT or ... ?
Date: 2001-05-13 01:44:03
Message-ID: 21950.989718243@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The Hermit Hacker <scrappy(at)hub(dot)org> 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Hollomon 2001-05-13 01:46:32 Re: Re: PL/Python build
Previous Message Bruce Momjian 2001-05-13 01:43:16 Re: Re: 7.2 items