Re: select to_number('1,000', '999,999');

From: David Schweikert <dws(at)ee(dot)ethz(dot)ch>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: select to_number('1,000', '999,999');
Date: 2004-11-22 14:25:58
Message-ID: 20041122142558.GC4020@ee.ethz.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Nov 22, 2004 at 05:47:19 -0800, Stephan Szabo wrote:
>No, but I think you're supposed to use FM in such cases.
>
>select to_number(1000, 'FM999,999');

Indeed, it works with 'FM'.

Thanks!
David
--
David Schweikert | phone: +41 44 632 7019
System manager ISG.EE | walk: ETH Zentrum, ETL F24.1
ETH Zurich, Switzerland | web: http://people.ee.ethz.ch/dws

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-11-22 16:08:56 Re: select to_number('1,000', '999,999');
Previous Message Siva Ganesh 2004-11-22 14:17:55 Hi