Re: to_char bug? - Mailing list pgsql-general

Ben Trewern wrote:
> Is there any reason why :
>
> SELECT char_length(to_char(1, '000'));
>
> Gives a result
>
>  char_length
> -------------
>            4
> (1 row)
>
> It seems that to_char(1, '000') gives a string " 001" with a space in front.
> Is this a bug?
>
> Regards,
>
> Ben
>
Try formatting the result:
SELECT char_length(to_char(1, 'fm000'));

char_length
-------------
            3