On 09/03/2011 13:15, Pavel Stehule wrote:
2011/3/9 Dmitriy Igrishin<[email protected]>:
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
[email protected]
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
