Received: from fondos.net (fondos.net [208.234.1.135]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA17679 for ; Fri, 19 Nov 1999 10:25:06 -0500 (EST) (envelope-from oserra@fondos.net) Received: from fondos.net ([195.235.124.77]) by fondos.net (8.8.8/8.8.5) with ESMTP id KAA31857 for ; Fri, 19 Nov 1999 10:25:04 -0500 Message-ID: <38356BC4.7DE4A74D@fondos.net> Date: Fri, 19 Nov 1999 16:24:52 +0100 From: Oscar Serrano X-Mailer: Mozilla 4.08 [en] (Win98; I) MIME-Version: 1.0 To: pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] ResultSet.getDate References: <18293.942678010@sss.pgh.pa.us> <012901bf2fa3$d25c43e0$0501a8c0@noonoo> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi: I'm from Spain. I've exported some tables from MS Access to Postgres. You know, in Spain, a number like this: 1,234.56 me write it like this: 1.234,56 i.e., the thousand separator is the "." and the decimal separator is the "," I'm going to use Perl (DBI) to get the data from the databases. Is there anyway so DBI or postgress gives me the data in the spanish format? I wouldn't like to use somethink like this: $result=~s/\./,/g; to convert all "." to "," and vice-versa. Thanks -- ______________________________ Oscar Serrano http://www.fondos.net http://www.mercados.net