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
