| 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: | Whole Thread | Raw Message | 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
| 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? |