Search Postgresql Archives

Convert number to string

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 ?

 

Thanks In advance




Avast logo

This email has been checked for viruses by Avast antivirus software.
www.avast.com



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux