Horton

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

David Schweikert <dws@ee.ethz.ch>

View thread
From: David Schweikert <dws@ee.ethz.ch>
To: pgsql-bugs@postgresql.org
Date: 2004-11-22T14:25:58Z
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