Received: from druid.net (root@druid.net [198.96.119.226]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA02080 for ; Wed, 12 May 1999 11:14:22 -0400 (EDT) (envelope-from darcy@druid.net) Received: from localhost (1375 bytes) by druid.net via sendmail with P:stdio/R:bind_hosts/T:inet_zone_bind_smtp (sender: ) (ident using unix) id for ; Wed, 12 May 1999 11:13:16 -0400 (EDT) (Smail-3.2.0.104 1998-Nov-20 #4 built 1999-Apr-13) Message-Id: Subject: Re: [SQL] question about money type In-Reply-To: from Marcio Macedo at "May 12, 1999 10:54:03 am" To: marciom@conectiva.com.br (Marcio Macedo) Date: Wed, 12 May 1999 11:13:16 -0400 (EDT) From: "D'Arcy" "J.M." Cain Cc: pgsql-sql@postgreSQL.org Reply-To: pgsql-sql@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL50 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit 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. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.