On 09/03/2011 13:15, Pavel Stehule wrote:
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?
I've often wondered too why there is padding by default in certain uses of to_char().... it's a bit of a PITA sometimes. :-)
Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
