Re: Baffled by "Group By" - Please help! - Mailing list pgsql-general

From Tom Lane
Subject Re: Baffled by "Group By" - Please help!
Date
Msg-id 5881.985469683@sss.pgh.pa.us
Whole thread Raw
In response to Baffled by "Group By" - Please help!  ("Matt Friedman" <matt@daart.ca>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Matt Friedman"
Date:
Subject: Baffled by "Group By" - Please help!
Next
From: "Matt Friedman"
Date:
Subject: Re: Baffled by "Group By" Resolved and Thanks