2011/3/9 Pavel Stehule <pavel.steh...@gmail.com> > 2011/3/9 Dmitriy Igrishin <dmit...@gmail.com>: > > > > > > 2011/3/9 Pavel Stehule <pavel.steh...@gmail.com> > >> > >> 2011/3/9 Dmitriy Igrishin <dmit...@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 ? > > yes > > pavel=# select '>' || to_char(-1,'9') || '<'; > ?column? > ────────── > >-1< > (1 row) >
Aha! Thanks. > > regards > > Pavel > > >> > >> Regards > >> > >> Pavel > >> > >> > > >> > -- > >> > // Dmitriy. > >> > > >> > > >> > > > > > > > > > -- > > // Dmitriy. > > > > > > > -- // Dmitriy.
