Convert numeric to money

From: lucas(at)presserv(dot)org
To: pgsql-sql(at)postgresql(dot)org
Subject: Convert numeric to money
Date: 2005-07-22 14:03:40
Message-ID: 20050722110340.4ogyzmonnny800sc@www.presserv.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi.
I have searched in mailing-list archives about converting types, but I couldn't
found a function or clause that convert a numeric type to money type.
How Can I convert this types?

=> select '1234'::money;
money
------------
R$1.234,00

=> select '1234'::numeric::money;
ERROR: cannot cast type numeric to money

The problem is becouse I have a table with "numeric" field, and I need to show
it like "money" type (R$ 1.234,00). Is there a function to convert it??? Or is
there a function to mask the numeric field to show like money (with
R$x.xxx,xx)???

Thanks.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mark R. Dingee 2005-07-22 15:49:21 Multi-column returns from pgsql
Previous Message Michael Fuhr 2005-07-22 13:51:56 Re: Error when using array variable