| From: | Dmitriy Igrishin <dmitigr(at)gmail(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| 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:51:34 |
| Message-ID: | AANLkTikP=t2hoq36TTS3Zx7mF7CzDivseUM6Y_tjbNYD@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2011/3/10 Bruce Momjian <bruce(at)momjian(dot)us>
> 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?
>
I propose to replace "fill mode (suppress padding blanks and zeroes)"
located here
http://www.postgresql.org/docs/9.0/static/functions-formatting.html#FUNCTIONS-FORMATTING-NUMERICMOD-TABLE
with
"fill mode (suppress padding blanks and trailing zeroes)".
>
> --
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + It's impossible for everything to be true. +
>
--
// Dmitriy.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2011-03-10 18:55:11 | Re: Upgraded to 9.0.3, No Man Pages |
| Previous Message | Bruce Momjian | 2011-03-10 18:39:08 | Re: Why length(to_char(1::integer, '9')) = 2 ? |