| From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Re: bug in JOIN or COUNT or ... ? |
| Date: | 2001-05-13 01:51:47 |
| Message-ID: | Pine.BSF.4.33.0105122251250.629-100000@mobile.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, 12 May 2001, Tom Lane wrote:
> 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().
Ahhhh, okay, that makes sense ... thanks for taking the time to check it
for me ... and explaining what I was missing ...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Hollomon | 2001-05-13 01:53:10 | Re: State of PL/Python build |
| Previous Message | Mark Hollomon | 2001-05-13 01:46:32 | Re: Re: PL/Python build |