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) regards Pavel >> >> Regards >> >> Pavel >> >> > >> > -- >> > // Dmitriy. >> > >> > >> > > > > > -- > // Dmitriy. > > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
