Ashley Cambrell ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
TO_CHAR(timestamp, 'Day') adds extra whitespace
Long Description
Using the postgresql TO_CHAR function with Day, DAY, day, Month, MONTH or month as the
text argument, extra whitespace is appended to the output.
It's easy enough to fixup on the client side, but it's pretty annoying.
Sample Code
SELECT TO_CHAR('2001-01-01'::date, 'Month');
to_char
-----------
January
(1 row)
SELECT LENGTH('January');
length
--------
7
(1 row)
SELECT LENGTH(TO_CHAR('2001-01-01'::date, 'Month'));
length
--------
9
(1 row)
ELECT TO_CHAR('2001-01-01'::date, 'Day');
to_char
-----------
Monday
(1 row)
SELECT LENGTH('Monday');
length
--------
6
(1 row)
SELECT LENGTH(TO_CHAR('2001-01-01'::date, 'Day'));
length
--------
9
(1 row)
-- notice requested single space after Monday
SELECT LENGTH('Monday ');
length
--------
7
(1 row)
-- notice requested single space after Day
SELECT LENGTH(TO_CHAR('2001-01-01'::date, 'Day '));
length
--------
10
(1 row)
No file was uploaded with this report
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
