Re: apply sum function after group by extract month date

e-letter <inpost(at)gmail(dot)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