Re: GROUPING

On Sat, 13 Oct 2001, Timothy J Hitchens 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;
>
You should write:

SELECT name_1 FROM telemetry where beat > 12 GROUP BY
name_1

because, you must indicate on "SELECT name_1" the attribute name for
GROUP it .

did you understand?

bye

Esteban Gutierrez.
egutierr(at)alumnos(dot)ubiobio(dot)cl

>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>