Re: Extra space when converting number with to_char - Mailing list pgsql-general

On Fri, Oct 26, 2012 at 04:11:42PM -0400, Samuel Gilbert wrote:
> Thank you, it works.  The documentation gave me the impression that the FM
> modifier only applied to date/time since it was under "Usage notes for
> date/time formatting:"

Uh, I see:

        <entry><literal>FM</literal> prefix</entry>
        <entry>fill mode (suppress padding blanks and trailing zeroes)</entry>
        <entry><literal>FM9999</literal></entry>

Does that need clarification?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +