On Thu, 30 Jun 2011 17:15:23 +0200, Mäggi Hieber <mhieber(at)sunrise(dot)ch> wrote:
> In our project table we have a column with costs, using data typ
> "money". By default PostgreSQL always applys '$', but we would like to
> have '€'.
> How can I change the data type "money" (currency) of a column in an
> existing table to '€'?
This is not such a good idea to use currencies' shortcuts, specially if your
program is to be internationalized or used with another currency (eg: there's
no shortcut for Swiss Franc) - for these reasons, you'd better use 3 letters
ISO-4217 codes http://www.xe.com/iso4217.php
Body by Nautilus, Brain by Mattel.
In response to
pgsql-novice by date
|Next:||From: Merlin Moncure||Date: 2011-06-30 21:06:50|
|Subject: Re: pg_advisory_locks in a multithreaded application context|
|Previous:||From: Ognjen Blagojevic||Date: 2011-06-30 20:02:51|
|Subject: Re: [NOVICE] change data type 'money' to '€'|