Postgres Pro
Downloads
Home   >   mailing lists

Re: change is gewd - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: change is gewd
Date
Msg-id Pine.LNX.4.21.0006040324130.348-100000@localhost.localdomain
Whole thread Raw
In response to change is gewd  (Hassanuri Bin Shah <uhassan@pc.jaring.my>)
List pgsql-admin
Tree view 
Hassanuri Bin Shah writes:

> does anyone knows how to change the currency symbol in 'money' type ?
>
> from '$' to 'RM'

`Money' has been deprecated for quite a while now. (The data type, not the
concept :) Use numeric for storage and to_char to format it to taste.

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

pgsql-admin by date:

Previous
From: "Nikolay Mijaylov"
Date:
Subject: RE: Web hosting and PostgreSQL?
Next
From: The Hermit Hacker
Date:
Subject: Re: Web hosting and PostgreSQL?