Re: problem - group by

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dusan PESL <D(dot)PESL(at)seznam(dot)cz>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: problem - group by
Date: 2007-05-19 17:32:35
Message-ID: 14265.1179595955@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

=?us-ascii?Q?Dusan=20PESL?= <D(dot)PESL(at)seznam(dot)cz> writes:
> in SQLite this query is posible:

> SELECT acount/1000, SUM(values) FROM acounts
> GROUP BY acount/1000

> this very simple and elegant way to get groups of common acounts,
> Unfortunately Postgres doesn't alow "GROUP BY acount/1000" -

Really? It works for me ...

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas 2007-05-20 18:15:34 How export from 8.2.4 down to 8.1.8
Previous Message coder 2007-05-18 19:27:47 Re: [NOVICE] aggregate function ?