Received: from mss.rdc2.nsw.optushome.com.au (ha1.rdc2.nsw.optushome.com.au [203.164.2.50]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9D1DWr10518 for ; Fri, 12 Oct 2001 21:13:33 -0400 (EDT) (envelope-from tim@hitcho.com.au) Received: from father ([203.164.196.220]) by mss.rdc2.nsw.optushome.com.au (InterMail vM.4.01.03.20 201-229-121-120-20010223) with ESMTP id <20011013011328.GLMX13193.mss.rdc2.nsw.optushome.com.au@father> for ; Sat, 13 Oct 2001 11:13:28 +1000 Reply-To: From: "Timothy J Hitchens" To: Subject: GROUPING Date: Sat, 13 Oct 2001 11:15:03 +1000 Organization: HITCHO Group Message-ID: <001101c15384$7d0cbda0$0a00a8c0@father> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 X-Archive-Number: 200110/162 X-Sequence-Number: 5117 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; Result: Attribute telemetry.rpvuid must be GROUPed or used in an aggregate function Oh then if I include rpvuid I get you must include this field and on it goes. Thanks... Timothy J Hitchens tim@hitcho.com.au