2011/3/9 Dmitriy Igrishin <dmitigr@xxxxxxxxx>: > > > 2011/3/9 Pavel Stehule <pavel.stehule@xxxxxxxxx> >> >> 2011/3/9 Dmitriy Igrishin <dmitigr@xxxxxxxxx>: >> > 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) regards Pavel >> >> Regards >> >> Pavel >> >> > >> > -- >> > // Dmitriy. >> > >> > >> > > > > > -- > // Dmitriy. > > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
