Postgres Pro
Downloads
Home   >   mailing lists

Re: to_char bug? - Mailing list pgsql-general

From Tom Lane
Subject Re: to_char bug?
Date
Msg-id 794.1109627049@sss.pgh.pa.us
Whole thread Raw
In response to to_char bug?  ("Ben Trewern" <bendottrewern@mowlem.com>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Shachar Shemesh
Date:
Subject: Re: Unicode support on Win32
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Clay Shirky observation regarding MySQL