Обсуждение: problem - group by

Hello,

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"- only "GROUP BY acount", which is not the same. 

I know, there are several ways, how to solve this problem, but the metod "GROUP BY acount/1000" seems to be the most
elegant.Can anyone help me? 

Thanks Dusan

=?us-ascii?Q?Dusan=20PESL?= <D.PESL@seznam.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