*** ./expected/int8.out Fri Sep 20 09:44:55 2002 --- ./results/int8.out Fri Mar 21 14:57:18 2003 *************** *** 160,166 **** | 4567890123456789 | 123 | 4567890123456789 ! | -4567890123456789 (5 rows) SELECT '' AS to_char_6, to_char(q2, 'FMS9999999999999999') FROM INT8_TBL; --- 160,166 ---- | 4567890123456789 | 123 | 4567890123456789 ! | --4567890123456789 (5 rows) SELECT '' AS to_char_6, to_char(q2, 'FMS9999999999999999') FROM INT8_TBL; *************** *** 175,181 **** SELECT '' AS to_char_7, to_char(q2, 'FM9999999999999999THPR') FROM INT8_TBL; to_char_7 | to_char ! -----------+-------------------- | 456TH | 4567890123456789TH | 123RD --- 175,181 ---- SELECT '' AS to_char_7, to_char(q2, 'FM9999999999999999THPR') FROM INT8_TBL; to_char_7 | to_char ! -----------+--------------------- | 456TH | 4567890123456789TH | 123RD *************** *** 185,196 **** SELECT '' AS to_char_8, to_char(q2, 'SG9999999999999999th') FROM INT8_TBL; to_char_8 | to_char ! -----------+--------------------- | + 456th | +4567890123456789th | + 123rd | +4567890123456789th ! | -4567890123456789 (5 rows) SELECT '' AS to_char_9, to_char(q2, '0999999999999999') FROM INT8_TBL; --- 185,196 ---- SELECT '' AS to_char_8, to_char(q2, 'SG9999999999999999th') FROM INT8_TBL; to_char_8 | to_char ! -----------+---------------------- | + 456th | + 4567890123456789th | + 123rd | + 4567890123456789th ! | --4567890123456789 (5 rows) SELECT '' AS to_char_9, to_char(q2, '0999999999999999') FROM INT8_TBL; *************** *** 275,285 **** SELECT '' AS to_char_17, to_char(q2, '999999SG9999999999') FROM INT8_TBL; to_char_17 | to_char ! ------------+------------------- | + 456 | 456789+0123456789 | + 123 | 456789+0123456789 ! | 456789-0123456789 (5 rows) --- 275,285 ---- SELECT '' AS to_char_17, to_char(q2, '999999SG9999999999') FROM INT8_TBL; to_char_17 | to_char ! ------------+-------------------- | + 456 | 456789+0123456789 | + 123 | 456789+0123456789 ! | -456789-0123456789 (5 rows) ====================================================================== *** ./expected/numeric.out Fri Mar 21 07:39:27 2003 --- ./results/numeric.out Fri Mar 21 14:57:21 2003 *************** *** 765,778 **** -----------+------------------------------------ | .000000000000000 | .000000000000000 ! | - 34338492.215397047000000 | 4.310000000000000 | 7799461.411900000000000 | 16397.038491000000000 | 93901.577630260000000 ! | - 83028485.000000000000000 | 74881.000000000000000 ! | - 24926804.045047420000000 (10 rows) SELECT '' AS to_char_6, to_char(val, 'FMS9999999999999999.999999999999999') FROM num_data; --- 765,778 ---- -----------+------------------------------------ | .000000000000000 | .000000000000000 ! | - -34338492.215397047000000 | 4.310000000000000 | 7799461.411900000000000 | 16397.038491000000000 | 93901.577630260000000 ! | - -83028485.000000000000000 | 74881.000000000000000 ! | - -24926804.045047420000000 (10 rows) SELECT '' AS to_char_6, to_char(val, 'FMS9999999999999999.999999999999999') FROM num_data; *************** *** 792,823 **** SELECT '' AS to_char_7, to_char(val, 'FM9999999999999999.999999999999999THPR') FROM num_data; to_char_7 | to_char ! -----------+---------------------- ! | 0. ! | 0. | <34338492.215397047> ! | 4.31 ! | 7799461.4119 ! | 16397.038491 ! | 93901.57763026 | <83028485.> ! | 74881. | <24926804.04504742> (10 rows) SELECT '' AS to_char_8, to_char(val, 'SG9999999999999999.999999999999999th') FROM num_data; to_char_8 | to_char ! -----------+----------------------------------- | + .000000000000000 | + .000000000000000 ! | - 34338492.215397047000000 | + 4.310000000000000 | + 7799461.411900000000000 | + 16397.038491000000000 | + 93901.577630260000000 ! | - 83028485.000000000000000 | + 74881.000000000000000 ! | - 24926804.045047420000000 (10 rows) SELECT '' AS to_char_9, to_char(val, '0999999999999999.999999999999999') FROM num_data; --- 792,823 ---- SELECT '' AS to_char_7, to_char(val, 'FM9999999999999999.999999999999999THPR') FROM num_data; to_char_7 | to_char ! -----------+------------------------------------- ! | .000000000000000TH ! | .000000000000000TH | <34338492.215397047> ! | 4.310000000000000TH ! | 7799461.411900000000000TH ! | 16397.038491000000000TH ! | 93901.577630260000000TH | <83028485.> ! | 74881.000000000000000TH | <24926804.04504742> (10 rows) SELECT '' AS to_char_8, to_char(val, 'SG9999999999999999.999999999999999th') FROM num_data; to_char_8 | to_char ! -----------+------------------------------------ | + .000000000000000 | + .000000000000000 ! | - -34338492.215397047000000 | + 4.310000000000000 | + 7799461.411900000000000 | + 16397.038491000000000 | + 93901.577630260000000 ! | - -83028485.000000000000000 | + 74881.000000000000000 ! | - -24926804.045047420000000 (10 rows) SELECT '' AS to_char_9, to_char(val, '0999999999999999.999999999999999') FROM num_data; *************** *** 958,965 **** SELECT '' AS to_char_18, to_char(val, 'S 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 . 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9') FROM num_data; to_char_18 | to_char ------------+----------------------------------------------------------------------- ! | . +0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ! | . +0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | -3 4 3 3 8 4 9 2 . 2 1 5 3 9 7 0 4 7 0 0 0 0 0 0 0 0 | +4 . 3 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | +7 7 9 9 4 6 1 . 4 1 1 9 0 0 0 0 0 0 0 0 0 0 0 0 0 --- 958,965 ---- SELECT '' AS to_char_18, to_char(val, 'S 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 . 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9') FROM num_data; to_char_18 | to_char ------------+----------------------------------------------------------------------- ! | +. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ! | +. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | -3 4 3 3 8 4 9 2 . 2 1 5 3 9 7 0 4 7 0 0 0 0 0 0 0 0 | +4 . 3 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | +7 7 9 9 4 6 1 . 4 1 1 9 0 0 0 0 0 0 0 0 0 0 0 0 0 *************** *** 1002,1018 **** SELECT '' AS to_char_21, to_char(val, '999999SG9999999999') FROM num_data; to_char_21 | to_char ! ------------+------------------- | + 0 | + 0 ! | - 34338492 | + 4 | + 7799461 | + 16397 | + 93902 ! | - 83028485 | + 74881 ! | - 24926804 (10 rows) SELECT '' AS to_char_22, to_char(val, 'FM9999999999999999.999999999999999') FROM num_data; --- 1002,1018 ---- SELECT '' AS to_char_21, to_char(val, '999999SG9999999999') FROM num_data; to_char_21 | to_char ! ------------+-------------------- | + 0 | + 0 ! | - -34338492 | + 4 | + 7799461 | + 16397 | + 93902 ! | - -83028485 | + 74881 ! | - -24926804 (10 rows) SELECT '' AS to_char_22, to_char(val, 'FM9999999999999999.999999999999999') FROM num_data; ======================================================================