Re: Why length(to_char(1::integer, '9')) = 2 ?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, Sim Zacks <sim(at)compulab(dot)co(dot)il>
Subject: Re: Why length(to_char(1::integer, '9')) = 2 ?
Date: 2011-03-10 18:39:08
Message-ID: 201103101839.p2AId8t12834@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dmitriy Igrishin wrote:
> dmitigr=> SELECT '>'||to_char(0.1, '0.99999')||'<' AS v;
> v
> ------------
> > 0.10000<
>
> dmitigr=> SELECT '>'||to_char(0.1, 'FM0.99999')||'<' AS v;
> v
> -------
> >0.1<
>
> So, padding zeroes suppressed by FM is a rest of the value.

Any documentation changes suggested?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitriy Igrishin 2011-03-10 18:51:34 Re: Why length(to_char(1::integer, '9')) = 2 ?
Previous Message Rich Shepard 2011-03-10 17:57:19 Upgraded to 9.0.3, No Man Pages