Re: Why length(to_char(1::integer, '9')) = 2 ? - Mailing list pgsql-general

On 09/03/2011 13:15, Pavel Stehule wrote:
> 2011/3/9 Dmitriy Igrishin<dmitigr@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
rod@iol.ie