"Ben Trewern" <[EMAIL PROTECTED]> writes: > It seems that to_char(1, '000') gives a string " 001" with a space in front. > Is this a bug?
No. Possibly you want 'FM000'. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]