Re: reformatting floats ? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: reformatting floats ?
Date
Msg-id 20071206183747.GC17812@svana.org
Whole thread Raw
In response to reformatting floats ?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
On Thu, Dec 06, 2007 at 01:22:55PM -0500, Gauthier, Dave wrote:
> i get...
>
>             1,1,2.001
>
> i want...
>
>             1.1.000,2.001
>
> while retaining the numeric nature of the x,y data (for math ops in
> other operations).

I imagine you want to_char().

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

Attachment

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: reformatting floats ?
Next
From: SHARMILA JOTHIRAJAH
Date:
Subject: Re: record-based log shipping