| From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: group by weirdness |
| Date: | 2001-09-13 21:31:53 |
| Message-ID: | 3BA125C9.5020304@selectacast.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Josh Berkus wrote:
> Joseph,
>
> The subject line could describe a lot of what I see outside my house
> every day (I live in San Francisco CA).
>
>
>>Could someome explain these error messages to me? Why am I being
>>asked to group by j.id?
>>
>
> Because you've asked the db engine to count on mj.mid. The parser want
> you to be specific about whether the other columns are being aggregated
> or not.
But they are in seperate tables, so how could it think they could be aggregated together?
--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joseph Shraibman | 2001-09-13 21:53:42 | Re: group by weirdness |
| Previous Message | Peter Eisentraut | 2001-09-13 17:18:14 | Re: query time |