On 09/03/2011 13:15, Pavel Stehule wrote:
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?
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
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
