Re: Convert number to string

John R Pierce <pierce@xxxxxxxxxxxx> · Thu, 24 Sep 2015 01:16:26 -0700



    On 9/24/2015 1:09 AM, Hengky Liwandouw
      wrote:

    
      Hi,
       
      I don’t have any idea how can I use postgres
        function to
        convert series  of number (currency) to my own string. 
       
      My string         :
        F G H I J K L M N  as the replacement for number : 1 2 3 4 5 6 7
        8 9
      Dozens = O
      Hundreds = P
      Thousands = C
      Ten thousands = B
       
      So… 
      200 = GP
      2000 = GC
      1150 = FFJO
      30000 = HB
       
      Any idea ?
       
    
    going from FFJO -> 1150 is simple character substitution
    (assuming 'dozens' actually means tens, and not its traditional
    meaning of 12s).

    
    going the other way, thats probably a good excuse for a plperl
    function.

    
    -- 
john r pierce, recycling bits in santa cruz