> Hi Bruce,
>
> a fix for what?
> If you're meaning the leading space, then the fix is in the followup post
> that I made to my original quiestion. i.e.
>
> psql -c "select to_char(12,'xFM000');"
> to_char
> ---------
> x012
> (1 row)
>
> The 'FM' removes the space.
So the FM is the correct way to do this, right? There is no bug?
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
