Convert number to string - Mailing list pgsql-general

From Hengky Liwandouw
Subject Convert number to string
Date
Msg-id 000601d0f6a0$5bf61ac0$13e25040$@com
Whole thread Raw
Responses Re: Convert number to string
List pgsql-general

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


pgsql-general by date:

Previous
From: David Rowley
Date:
Subject: Re: Automatically Updatable Foreign Key Views
Next
From: John R Pierce
Date:
Subject: Re: Convert number to string