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