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

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