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

2011/3/9 Sim Zacks <sim(at)compulab(dot)co(dot)il>

>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 03/09/2011 03:12 PM, Dmitriy Igrishin wrote:
>
> > Hey all,
> >
> > dmitigr=> select to_char(1, '9');
> > to_char
> > ---------
> > 1
> >
> > dmitigr=> select length(to_char(1, '9'));
> > length
> > --------
> > 2
> >
> > Why to_char() includes preceding blank space in the result ?
> >
> > --
> > // Dmitriy.
> >
> >
> I don't know why, but to work around it use:
> select to_char(1, 'FM9');
> select length(to_char(1, 'FM9'));
>
Thanks!

But I am missing something or there is a documentation inaccuracy:
http://www.postgresql.org/docs/9.0/static/functions-formatting.html#FUNCTIONS-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?

> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.10 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iQEcBAEBAgAGBQJNd3/JAAoJEHr2Gm0ENObOsUMH/ApWyfc5c5A56m1pAP7raIEd
> dmY0/aocCCnQbariREZIGSJPrmcWDKnNe3yNLjV2Y3+EY+eaicxy2GPTVamOrfqN
> tYQ/ImH3IkrzQk1bfRX+lnUJQGEmMi8ClzAatKUIifGJwMuj7y1xUl/VBTP0lBvI
> GuQQaElNkpGaPRTJZlorrtqEBgWmiyBT07gK02IST9xFsUPnrF0niNlqcaphF2Ga
> kKgFfVJ8u/C3KbwowVPh5GYZHgIM1T8x6SPzpcsnFVrIGN+avnuvdEInxomCZDNN
> FLuRBEPK9NFTG6rdIyrtfy5C6HVm/q7rO1alW0hjuszou1t2gBCOkmXtva9V5gY=
> =pGTI
> -----END PGP SIGNATURE-----
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
// Dmitriy.