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?
byeEsteban Gutierrez.egutierr@alumnos.ubiobio.cl
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>