Postgres Pro
Downloads
Home   >   mailing lists

length of return value of to_char() - Mailing list pgsql-general

From Seb
Subject length of return value of to_char()
Date
Msg-id 87liy01tlc.fsf@kolob.subpolar.dyndns.org
Whole thread Raw
Responses Re: length of return value of to_char()  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-general
Tree view 
Hi,

I thought this should be equal to 4:

# SELECT length(to_char(11, '0999'));
 length
--------
      5
(1 row)

but the string returned by the to_char() call is 0011 (length 4).  What
am I missing?

Thanks,

--
Seb

pgsql-general by date:

Previous
From: Wei
Date:
Subject: Fwd: Unable to Install - "unable to write inside TEMP environment variable path"
Next
From: Michael Glaesemann
Date:
Subject: Re: length of return value of to_char()