Re: Extra space when converting number with to_char

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Extra space when converting number with to_char
Дата
Msg-id 20121107194923.GA26215@momjian.us
обсуждение исходный текст
Ответ на Re: Extra space when converting number with to_char  (Samuel Gilbert <samuel.gilbert@ec.gc.ca>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: help with upgrade from 9.1 to 9.2
Следующее
От: Lists
Дата:
Сообщение: Re: Unexpectedly high disk space usage