Skip site navigation (1) Skip section navigation (2)

Re: change data type 'money' to '€'

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: Mäggi Hieber <mhieber(at)sunrise(dot)ch>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: change data type 'money' to '€'
Date: 2011-06-30 20:34:51
Message-ID: 20110630223451.144ee58c@anubis.defcon1 (view raw or flat)
Thread:
Lists: pgsql-novice
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 MoncureDate: 2011-06-30 21:06:50
Subject: Re: pg_advisory_locks in a multithreaded application context
Previous:From: Ognjen BlagojevicDate: 2011-06-30 20:02:51
Subject: Re: [NOVICE] change data type 'money' to '€'

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group