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

2010-03-04 Thread Tom Lane
"Erik Rijkers" 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

[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) repl