"Ben Trewern" <bendottrewern(at)mowlem(dot)com> writes:
> It seems that to_char(1, '000') gives a string " 001" with a space in front.
> Is this a bug?
Possibly you want 'FM000'.
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Martijn van Oosterhout||Date: 2005-02-28 22:00:32|
|Subject: Re: Clay Shirky observation regarding MySQL|
|Previous:||From: Shachar Shemesh||Date: 2005-02-28 21:09:38|
|Subject: Re: Unicode support on Win32|