Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de [53.2.131.8]) by hub.org (8.9.3/8.9.3) with SMTP id MAA12457 for ; Wed, 12 May 1999 12:20:59 -0400 (EDT) (envelope-from wieck@sapserv.debis.de) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@postgreSQL.org id m10hb6j-000EBbC; Wed, 12 May 99 17:39 MET DST Message-Id: From: jwieck@debis.com (Jan Wieck) Subject: Re: [SQL] question about money type To: pgsql-sql@postgreSQL.org Date: Wed, 12 May 1999 17:39:41 +0200 (MET DST) Cc: marciom@conectiva.com.br Reply-To: jwieck@debis.com (Jan Wieck) In-Reply-To: from "D'Arcy" "J.M." Cain" at May 12, 99 11:13:16 am X-Mailer: ELM [version 2.4 PL25] Content-Type: text D'Arcy J.M. Cain wrote: > > Thus spake Marcio Macedo > > 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$") ? > > Not really. There was once some discussion about removing the currency > string altogether on output (I even sent in patches) but it was decided > to keep it in because no one will be using the MONEY type eventually. > Everyone is being urged to use the NUMERIC type. I really wanted to add TO_CHAR() function for NUMERIC before release. But there are more important items in the rewrite system I have to fix first. Since TO_CHAR() cannot have any side effects I could add it until the last hour before Marc starts "closed shop". Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #======================================== jwieck@debis.com (Jan Wieck) #