| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Samuel Gilbert <samuel(dot)gilbert(at)ec(dot)gc(dot)ca> |
| Cc: | pgsql-general(at)postgresql(dot)org, Moshe Jacobson <moshe(at)neadwerx(dot)com> |
| Subject: | Re: Extra space when converting number with to_char |
| Date: | 2012-11-07 19:49:23 |
| Message-ID: | 20121107194923.GA26215@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lists | 2012-11-07 19:54:48 | Re: Unexpectedly high disk space usage |
| Previous Message | Bruce Momjian | 2012-11-07 19:14:48 | Re: help with upgrade from 9.1 to 9.2 |