From: | "Matt Friedman" <matt(at)daart(dot)ca> |
---|---|
To: | "PgSql General List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Baffled by "Group By" Resolved and Thanks |
Date: | 2001-03-24 21:47:40 |
Message-ID: | 000701c0b4ac$0d589e60$03284d18@mattq3h8budilr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yeah, it was right under my nose. Figured it out just before I got your
email.
Thank you.
Matt Friedman
----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Matt Friedman" <matt(at)sprynewmedia(dot)com>
Cc: "PgSql General List" <pgsql-general(at)postgresql(dot)org>
Sent: Saturday, March 24, 2001 1:34 PM
Subject: Re: Baffled by "Group By" - Please help!
> "Matt Friedman" <matt(at)daart(dot)ca> writes:
> > What am I missing? I'm not seeing why this query doesn't group
everything
> > and then return unique rows.
>
> Since you didn't show an example of the input and output, it's hard to
> tell what your gripe is ... but I'll venture that you didn't want to
> group by index.word_count. It doesn't make a lot of sense to group by
> something you are using as an aggregate input.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Barnes | 2001-03-24 23:29:58 | Re: HOWTO for pg 7.1 installation from cvs |
Previous Message | Tom Lane | 2001-03-24 21:34:43 | Re: Baffled by "Group By" - Please help! |