From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Dmitriy Igrishin <dmitigr(at)gmail(dot)com>, Sim Zacks <sim(at)compulab(dot)co(dot)il> |
Subject: | Re: Why length(to_char(1::integer, '9')) = 2 ? |
Date: | 2011-03-09 15:42:12 |
Message-ID: | 201103090742.13601.adrian.klaver@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | John Edens | 2011-03-09 16:30:37 | How to configure for remote TCP/IP client conncections using MS Visual Basic OLE DB calls and PostgreSQL dll's? |
Previous Message | Andrew Sullivan | 2011-03-09 15:42:08 | Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8 |