The following bug has been logged online:
Bug reference: 3237
Logged by: Robert wang
Email address: robert.wang@eitec.com.tw
PostgreSQL version: 8.2
Operating system: Windows 2000 professional
Description: function to_char() returns wrong value
Details:
I run this following SQL command in pgAdminIII:
Select to_char(12345,'00000')
but it always returns ' 12345' (hex code: 20 31 32 33 34 35).It always adds
one space char in the left side.
I have to use another function substring() as followings to get my expected
value.
Select substring(to_char(12345,'00000'),from ' ' for 5)
it exactly returns '12345' which I expect.