On Wednesday, March 09, 2011 5:34:41 am Dmitriy Igrishin wrote: > > But I am missing something or there is a documentation inaccuracy: > http://www.postgresql.org/docs/9.0/static/functions-formatting.html#FUNCTIO > NS-FORMATTING-NUMERICMOD-TABLEsays: fill mode (suppress padding blanks and > zeroes) > > Test: > dmitigr=> select to_char(12,'FM0009'); > to_char > --------- > 0012 > > dmitigr=> select length(to_char(12,'FM0009')); > length > -------- > 4 > > So, FM suppresses only padding blanks not zeroes... > > Any comments? > test(5432)aklaver=>select to_char(12,'9999'); to_char --------- 12 test(5432)aklaver=>select to_char(12,'FM9999'); to_char --------- 12 It is a little confusing, but you asked for the 0 in your specification so they are not considered padding. Look at the examples in the table listed below to get an idea of what I am talking about. http://www.postgresql.org/docs/9.0/static/functions-formatting.html Table 9-25 -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
