length of return value of to_char()

[Seb <spluque@xxxxxxxxx>]

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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general