From: | Dmitriy Igrishin <dmitigr(at)gmail(dot)com> |
---|---|
To: | adrian(dot)klaver(at)gmail(dot)com |
Cc: | 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-09 17:59:40 |
Message-ID: | AANLkTin8Txmaj0qeYfon_30PRtoGAaSma_=oHQi8UjaF@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2011/3/9 Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
> 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
>
Yes, I see, thanks!
I just talking about phrase "fill mode (suppress padding blanks and zeroes)"
in the documentation should be rephrased to "fill mode (suppress padding
blanks)".
Or I misunderstood what is "padding zeroes" without explicitly
specification "0" pattern in the format format template...
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>
--
// Dmitriy.
From | Date | Subject | |
---|---|---|---|
Next Message | John Edens | 2011-03-09 17:59:50 | Re: How to configure for remote TCP/IP client conncections using MS Visual Basic OLE DB calls and PostgreSQL dll's? |
Previous Message | John Edens | 2011-03-09 17:54:03 | Re: How to configure for remote TCP/IP client conncections using MS Visual Basic OLE DB calls and PostgreSQL dll's? |