Re: Baffled by "Group By" Resolved and Thanks
От | Matt Friedman |
---|---|
Тема | Re: Baffled by "Group By" Resolved and Thanks |
Дата | |
Msg-id | 000701c0b4ac$0d589e60$03284d18@mattq3h8budilr обсуждение исходный текст |
Ответ на | Baffled by "Group By" - Please help! ("Matt Friedman" <matt@daart.ca>) |
Список | 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 по дате отправления: