Postgres Pro
Downloads
Home   >   mailing lists

Re: problem - group by - Mailing list pgsql-novice

From Tom Lane
Subject Re: problem - group by
Date
Msg-id 14265.1179595955@sss.pgh.pa.us
Whole thread Raw
In response to problem - group by  (Dusan PESL <D.PESL@seznam.cz>)
List pgsql-novice
Tree view 
=?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

pgsql-novice by date:

Previous
From: Chris Browne
Date:
Subject: Re: Ocaml as a Postgresql Procedural Language?
Next
From: Andreas
Date:
Subject: How export from 8.2.4 down to 8.1.8