Re: Format Float numbers

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: <fernandoxavier(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Format Float numbers
Date: 2008-01-10 13:49:04
Message-ID: D960CB61B694CF459DCFB4B0128514C2C4DB3C@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I want format a column in select result:
>
> 1.1 => 1.10
>
> Any idea?

Try the to_date() function like

SELECT to_char(1.1, '0.99');

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-01-10 13:49:17 Re: count(*) and bad design was: Experiences with extensibility
Previous Message A. Kretschmer 2008-01-10 13:21:44 Re: Format Float numbers