2011/3/10 Bruce Momjian <br...@momjian.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 <br...@momjian.us> http://momjian.us > EnterpriseDB http://enterprisedb.com > > + It's impossible for everything to be true. + > -- // Dmitriy.
