Re: Baffled by "Group By" Resolved and Thanks - Mailing list pgsql-general

From Matt Friedman
Subject Re: Baffled by "Group By" Resolved and Thanks
Date
Msg-id 000701c0b4ac$0d589e60$03284d18@mattq3h8budilr
Whole thread Raw
In response to Baffled by "Group By" - Please help!  ("Matt Friedman" <matt@daart.ca>)
List 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@sss.pgh.pa.us>
To: "Matt Friedman" <matt@sprynewmedia.com>
Cc: "PgSql General List" <pgsql-general@postgresql.org>
Sent: Saturday, March 24, 2001 1:34 PM
Subject: Re: Baffled by "Group By" - Please help!


> "Matt Friedman" <matt@daart.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@postgresql.org)
>
>


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Baffled by "Group By" - Please help!
Next
From: Bill Barnes
Date:
Subject: Re: HOWTO for pg 7.1 installation from cvs