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?

byeEsteban Gutierrez.egutierr@alumnos.ubiobio.cl
 


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