Обсуждение: function to_char

"Fontana Daniel C. \(Desartec S.R.L.\)" <desartecsrl@gmail.com> writes:
> Example, select length (to_char (1, '990'))
> returns 4 because?

Per the fine manual:

    * If no explicit provision is made for a sign in to_char()'s pattern,
      one column will be reserved for the sign, and it will be anchored to
      (appear just left of) the number. If S appears just left of some
      9's, it will likewise be anchored to the number.

If you don't want to leave space for a sign, it looks like FM is
the only way to do that.

            regards, tom lane