Postgres Pro
Downloads
Home   >   mailing lists

Re: select to_number('1,000', '999,999'); - Mailing list pgsql-bugs

From David Schweikert
Subject Re: select to_number('1,000', '999,999');
Date
Msg-id 20041122142558.GC4020@ee.ethz.ch
Whole thread Raw
In response to Re: select to_number('1,000', '999,999');  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: select to_number('1,000', '999,999');
Next
From: Tom Lane
Date:
Subject: Re: select to_number('1,000', '999,999');