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

On Sat, 12 May 2001, Tom Lane wrote:

> Ah, I see it: your join against relationship_wanted isn't unique.
>
> globalmatch=# select count(*) from personal_data pd
> globalmatch-# where pd.gid = 17111 AND pd.gender = 0;
>  count
> -------
>      1
> (1 row)
>
> globalmatch=# select count(*) from relationship_wanted rw
> globalmatch-# where rw.gid = 17111 AND rw.gender = 0;
>  count
> -------
>      5
> (1 row)
>
> globalmatch=#
>
> 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 ...