The following bug has been logged online: Bug reference: 3237 Logged by: Robert wang Email address: [EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
