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

[Bruce Momjian <bruce@xxxxxxxxxx>]

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@xxxxxxxxxx>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general