numeric.out

PostgreSQL7.4.6 for Linux

(10 rows)

SELECT '' AS to_char_10, to_char(val, 'S0999999999999999.999999999999999')      FROM num_data;	
 to_char_10 |              to_char              
------------+-----------------------------------
            | +0000000000000000.000000000000000
            | +0000000000000000.000000000000000
            | -0000000034338492.215397047000000
            | +0000000000000004.310000000000000
            | +0000000007799461.411900000000000
            | +0000000000016397.038491000000000
            | +0000000000093901.577630260000000
            | -0000000083028485.000000000000000
            | +0000000000074881.000000000000000
            | -0000000024926804.045047420000000
(10 rows)

SELECT '' AS to_char_11, to_char(val, 'FM0999999999999999.999999999999999')     FROM num_data;	
 to_char_11 |           to_char           
------------+-----------------------------
            | 0000000000000000.
            | 0000000000000000.
            | -0000000034338492.215397047
            | 0000000000000004.31
            | 0000000007799461.4119
            | 0000000000016397.038491
            | 0000000000093901.57763026
            | -0000000083028485.
            | 0000000000074881.
            | -0000000024926804.04504742
(10 rows)

SELECT '' AS to_char_12, to_char(val, 'FM9999999999999999.099999999999999') 	FROM num_data;
 to_char_12 |       to_char       
------------+---------------------
            | .0
            | .0
            | -34338492.215397047
            | 4.31
            | 7799461.4119
            | 16397.038491
            | 93901.57763026
            | -83028485.0
            | 74881.0
            | -24926804.04504742
(10 rows)

SELECT '' AS to_char_13, to_char(val, 'FM9999999999990999.990999999999999') 	FROM num_data;
 to_char_13 |       to_char       
------------+---------------------
            | 0000.000
            | 0000.000
            | -34338492.215397047
            | 0004.310
            | 7799461.4119
            | 16397.038491
            | 93901.57763026
            | -83028485.000
            | 74881.000
            | -24926804.04504742
(10 rows)

SELECT '' AS to_char_14, to_char(val, 'FM0999999999999999.999909999999999') 	FROM num_data;
 to_char_14 |           to_char           
------------+-----------------------------
            | 0000000000000000.00000
            | 0000000000000000.00000
            | -0000000034338492.215397047
            | 0000000000000004.31000
            | 0000000007799461.41190
            | 0000000000016397.038491
            | 0000000000093901.57763026
            | -0000000083028485.00000
            | 0000000000074881.00000
            | -0000000024926804.04504742
(10 rows)

SELECT '' AS to_char_15, to_char(val, 'FM9999999990999999.099999999999999') 	FROM num_data;
 to_char_15 |       to_char       
------------+---------------------
            | 0000000.0
            | 0000000.0
            | -34338492.215397047
            | 0000004.31
            | 7799461.4119
            | 0016397.038491
            | 0093901.57763026
            | -83028485.0
            | 0074881.0
            | -24926804.04504742
(10 rows)

SELECT '' AS to_char_16, to_char(val, 'L9999999999999999.099999999999999')	FROM num_data;	
 to_char_16 |              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_17, to_char(val, 'FM9999999999999999.99999999999999')	FROM num_data;
 to_char_17 |       to_char       
------------+---------------------
            | 0.
            | 0.
            | -34338492.215397047
            | 4.31
            | 7799461.4119
            | 16397.038491
            | 93901.57763026
            | -83028485.
            | 74881.
            | -24926804.04504742
(10 rows)

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
            |                        +1 6 3 9 7 . 0 3 8 4 9 1 0 0 0 0 0 0 0 0 0 0 0
            |                        +9 3 9 0 1 . 5 7 7 6 3 0 2 6 0 0 0 0 0 0 0 0 0
            |                  -8 3 0 2 8 4 8 5 . 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
            |                        +7 4 8 8 1 . 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
            |                  -2 4 9 2 6 8 0 4 . 0 4 5 0 4 7 4 2 0 0 0 0 0 0 0 0 0
(10 rows)

SELECT '' AS to_char_19, to_char(val, 'FMS 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_19 |                        to_char                        
------------+-------------------------------------------------------
            |                 +0 .                 
            |                 +0 .                 
            |          -3 4 3 3 8 4 9 2 . 2 1 5 3 9 7 0 4 7        
            |                 +4 . 3 1               
            |           +7 7 9 9 4 6 1 . 4 1 1 9             
            |             +1 6 3 9 7 . 0 3 8 4 9 1           
            |             +9 3 9 0 1 . 5 7 7 6 3 0 2 6         
            |          -8 3 0 2 8 4 8 5 .                 
            |             +7 4 8 8 1 .                 
            |          -2 4 9 2 6 8 0 4 . 0 4 5 0 4 7 4 2         
(10 rows)

SELECT '' AS to_char_20, to_char(val, '99999 "text" 9999 "9999" 999 "\\"text between quote marks\\"" 9999') FROM num_data;
 to_char_20 |                          to_char                          
------------+-----------------------------------------------------------
            |       text      9999     "text between quote marks"     0
            |       text      9999     "text between quote marks"     0
            |       text    -3 9999 433 "text between quote marks" 8492
            |       text      9999     "text between quote marks"     4
            |       text      9999  779 "text between quote marks" 9461
            |       text      9999    1 "text between quote marks" 6397
            |       text      9999    9 "text between quote marks" 3902
            |       text    -8 9999 302 "text between quote marks" 8485
            |       text      9999    7 "text between quote marks" 4881
            |       text    -2 9999 492 "text between quote marks" 6804
(10 rows)

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;
 to_char_22 |       to_char       
------------+---------------------
            | 0.
            | 0.
            | -34338492.215397047
            | 4.31
            | 7799461.4119
            | 16397.038491
            | 93901.57763026
            | -83028485.
            | 74881.
            | -24926804.04504742
(10 rows)

-- TO_NUMBER()
--
SELECT '' AS to_number_1,  to_number('-34,338,492', '99G999G999');
 to_number_1 | to_number 
-------------+-----------
             | -34338492
(1 row)

SELECT '' AS to_number_2,  to_number('-34,338,492.654,878', '99G999G999D999G999');
 to_number_2 |    to_number     
-------------+------------------
             | -34338492.654878
(1 row)

SELECT '' AS to_number_3,  to_number('<564646.654564>', '999999.999999PR');
 to_number_3 |   to_number    
-------------+----------------
             | -564646.654564
(1 row)

SELECT '' AS to_number_4,  to_number('0.00001-', '9.999999S');
 to_number_4 | to_number 
-------------+-----------
             |  -0.00001
(1 row)

SELECT '' AS to_number_5,  to_number('5.01-', 'FM9.999999S');
 to_number_5 | to_number 
-------------+-----------
             |     -5.01
(1 row)

SELECT '' AS to_number_5,  to_number('5.01-', 'FM9.999999MI');
 to_number_5 | to_number 
-------------+-----------
             |     -5.01
(1 row)

SELECT '' AS to_number_7,  to_number('5 4 4 4 4 8 . 7 8', '9 9 9 9 9 9 . 9 9');
 to_number_7 | to_number 
-------------+-----------
             | 544448.78
(1 row)

SELECT '' AS to_number_8,  to_number('.01', 'FM9.99');
 to_number_8 | to_number 
-------------+-----------
             |      0.01
(1 row)

SELECT '' AS to_number_9,  to_number('.0', '99999999.99999999');
 to_number_9 | to_number 
-------------+-----------
             |       0.0
(1 row)

SELECT '' AS to_number_10, to_number('0', '99.99');
 to_number_10 | to_number 
--------------+-----------
              |         0
(1 row)

SELECT '' AS to_number_11, to_number('.-01', 'S99.99');
 to_number_11 | to_number 
--------------+-----------
              |     -0.01
(1 row)

SELECT '' AS to_number_12, to_number('.01-', '99.99S');
 to_number_12 | to_number 
--------------+-----------
              |     -0.01
(1 row)

SELECT '' AS to_number_13, to_number(' . 0 1 -', ' 9 9 . 9 9 S');
 to_number_13 | to_number 
--------------+-----------
              |     -0.01
(1 row)