2011/3/9 Dmitriy Igrishin <dmitigr@gmail.com>: > > > 2011/3/9 Pavel Stehule <pavel.stehule@gmail.com> >> >> 2011/3/9 Dmitriy Igrishin <dmitigr@gmail.com>: >> > 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 ? >> >> it is compatibility with Oracle? > > Do you mean the case of MI ? > So, is this leading space reserved for a sign of number by default ?