[HACKERS] one-off error in to_char formatting

2010-03-04 Thread Erik Rijkers
ISTM this is a bug, no?

(9.0devel, cvs 2010.03.04 01:30)

replicas=# select length( to_char(1, '0') );
 length

  2
(1 row)

There seems to be an erroneously prefixed space:

replicas=# select '' || to_char(1, repeat('0',8)) || '';
  ?column?
-
  0001
(1 row)


replicas=# select version();
 version
--
 PostgreSQL 9.0devel-standby on x86_64-unknown-linux-gnu, compiled by GCC gcc 
(GCC) 4.4.3, 64-bit
(1 row)




Erik Rijkers


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


Re: [HACKERS] one-off error in to_char formatting

2010-03-04 Thread Tom Lane
Erik Rijkers e...@xs4all.nl writes:
 There seems to be an erroneously prefixed space:

No, that's where the sign goes.  You can suppress it with FM,
if you don't want fixed-width output.

regards, tom lane

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