"Ben Trewern" <bendottrewern@xxxxxxxxxx> 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 majordomo@xxxxxxxxxxxxxx
