Re: GROUPING

On Sat, 13 Oct 2001 03:32:57 +0000 (UTC), <tim(at)hitcho(dot)com(dot)au> wrote:
> It's been a while since I used postgresql but today I have converted one
> of my web apps but with one small problem. I goto do a group as
> designed and executed in mysql and I get told that this and this must be
> part of the aggreate etc I am puzzled and wonder if someone could bring
> me up to stratch with grouping in postgresql this is my current sql:
>
> SELECT * FROM telemetry WHERE beat > 12 GROUP BY buid;
>

I seem to recall reading something recently showing that mysql does
something completely different with GROUP from what postgres does.

Stephan posted a nice description of how GROUP works here.
It might help if we knew what you want the result of your query to be.