question about money type - Mailing list pgsql-sql

From Marcio Macedo
Subject question about money type
Date
Msg-id Pine.LNX.4.10.9905121049370.6347-100000@animaniacs.conectiva.com.br
Whole thread Raw
Responses Re: [SQL] question about money type  ("D'Arcy" "J.M." Cain <darcy@druid.net>)
List 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 MacedoConectiva




pgsql-sql by date:

Previous
From: "Adam H. Pendleton"
Date:
Subject: Function error
Next
From: "D'Arcy" "J.M." Cain
Date:
Subject: Re: [SQL] question about money type