Re: reformatting floats ?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: reformatting floats ?
Date: 2007-12-06 18:37:47
Message-ID: 20071206183747.GC17812@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy

In response to

Browse pgsql-general by date

  From Date Subject
Next Message SHARMILA JOTHIRAJAH 2007-12-06 18:42:41 Re: record-based log shipping
Previous Message Jeff Davis 2007-12-06 18:29:51 Re: record-based log shipping