e-letter <inpost@gmail.com> wrote:
I didn't understand the first part of your question. Be sure you
are clear about selecting a set of rows based on date and grouping
(summarizing) rows based on date (or some part of date?).
> How to change currency unit for the data type money, i.e. to
> change the currency sign from dollar ($) shown in a query result?
How do you have the locale information set? In particular,
lc_monetary?
test=# show lc_monetary ;
lc_monetary
-------------
en_US.UTF-8
(1 row)
test=# select '123.45'::money;
money
---------
$123.45
(1 row)
test=# set lc_monetary = 'en_GB.UTF-8';
SET
test=# select '123.45'::money;
money
---------
£123.45
(1 row)
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
