Re: Extra space when converting number with to_char

On 10/26/12 11:50, Samuel Gilbert wrote:
>
>    (SELECT to_char(42, '000000000') AS string) AS example;
>
>    string   | length | showthemtome
> ------------+--------+--------------
>   000000042 |     10 | " 000000042"

Sign padding.  Try using:
   select to_char(42, 'FM000000000') ...

To see why, look here:
http://www.postgresql.org/docs/9.2/static/functions-formatting.html#FUNCTIONS-FORMATTING-NUMERICMOD-TABLE

HTH

Bosco.