Formating numbers useing to_char: how to get rid of leading space? - Mailing list pgsql-general

I'm trying to format some numbers using to_char, like this:

    SELECT TO_CHAR(34, '099999');

Whenever I do this, I always get a leading space, if the int is
positive.  I looked at the manual, and all the examples had leading
spaces.  Is there a way to get rid of this using TO_CHAR, or should I
write my own formating function that does a TO_CHAR followed by a
LTRIM or something?  If that's the only way to do it, I guess I'll
eventually just write a C function that does numerical output.

Thanks,

e


--
This message was my two cents worth.  Please deposit two cents into my
e-gold account by following this link:
http://rootworks.com/twocentsworth.cgi?102861
275A B627 1826 D627 ED35  B8DF 7DDE 4428 0F5C 4454