Re: to_char bug?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ben Trewern" <bendottrewern(at)mowlem(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: to_char bug?
Date: 2005-02-28 21:44:09
Message-ID: 794.1109627049@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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?

No.

Possibly you want 'FM000'.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-02-28 22:00:32 Re: Clay Shirky observation regarding MySQL
Previous Message Shachar Shemesh 2005-02-28 21:09:38 Re: Unicode support on Win32