Postgres Pro
Downloads
Home   >   mailing lists

Thread: function to_char

function to_char

From
"Fontana Daniel C. \(Desartec S.R.L.\)"
Date:

Hi, using postgres 12.5.

 

The to_char function has a problem with format length.

 

Example, select length (to_char (1, '990'))

 

returns 4 because?

 

if the format has length 3?

 



Avast logo

El software de antivirus Avast ha analizado este correo electrónico en busca de virus.
www.avast.com


Re: function to_char

From
Tom Lane
Date:
"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