problem - group by - Mailing list pgsql-novice

Hello,

I have found the solution of "GROUP BY" problem. Instead of:

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

this query works:

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

so, forget my previous question...

Best regards Dusan