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

From Bruce Momjian
Subject Re: Extra space when converting number with to_char
Date
Msg-id 20121107194923.GA26215@momjian.us
Whole thread Raw
In response to Re: Extra space when converting number with to_char  (Samuel Gilbert <samuel.gilbert@ec.gc.ca>)
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. +


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: help with upgrade from 9.1 to 9.2
Next
From: Lists
Date:
Subject: Re: Unexpectedly high disk space usage