Postgres Pro
Downloads
Home   >   mailing lists

Why length(to_char(1::integer, '9')) = 2 ? - Mailing list pgsql-general

From Dmitriy Igrishin
Subject Why length(to_char(1::integer, '9')) = 2 ?
Date
Msg-id AANLkTimM7i23Xe6A1vF=cgrLBF0j5ekjRpKQ2i2Am-rX@mail.gmail.com
Whole thread Raw
Responses Re: Why length(to_char(1::integer, '9')) = 2 ?  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Why length(to_char(1::integer, '9')) = 2 ?  (Sim Zacks <sim@compulab.co.il>)
List pgsql-general
Tree view
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.


pgsql-general by date:

Previous
From: Chetan Suttraway
Date:
Subject: Re: Composite index structure
Next
From: Pavel Stehule
Date:
Subject: Re: Why length(to_char(1::integer, '9')) = 2 ?