"Ben Trewern" <bendottrewern@mowlem.com> 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@postgresql.org