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 



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to