Re: to_char bug?

[Bricklen Anderson <BAnderson@xxxxxxxxxxxx>]

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq