GROUPING

From: "Timothy J Hitchens" <tim(at)hitcho(dot)com(dot)au>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: GROUPING
Date: 2001-10-13 01:15:03
Message-ID: 001101c15384$7d0cbda0$0a00a8c0@father
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)hitcho(dot)com(dot)au

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Oleg Lebedev 2001-10-13 01:57:34 DROP VIEWS
Previous Message Josh Berkus 2001-10-12 22:08:42 Re: MEDIAN as custom aggregate?