question about money type

From: Marcio Macedo <marciom(at)conectiva(dot)com(dot)br>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: question about money type
Date: 1999-05-12 13:54:03
Message-ID: Pine.LNX.4.10.9905121049370.6347-100000@animaniacs.conectiva.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hi all,

when I do a SELECT in a money field, it returns the folowing :

R$2.244,00

what is correct , according with my LOCALE settings,
is there a way to format this result to

2.244,00 (without the "R$") ?

--Marcio Macedo
Conectiva

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message D'Arcy J.M. Cain 1999-05-12 15:13:16 Re: [SQL] question about money type
Previous Message Adam H. Pendleton 1999-05-12 13:40:24 Function error