Re: Convert number to string - Mailing list pgsql-general

From Francisco Olarte
Subject Re: Convert number to string
Date
Msg-id CA+bJJbyioOUH80sa_HbdhyOR_+iVt1p4yMmYU=7pLM5iWoey0Q@mail.gmail.com
Whole thread Raw
In response to Re: Convert number to string  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
HI Melvin:

On Thu, Sep 24, 2015 at 2:51 PM, Melvin Davidson <melvin6925@gmail.com> wrote:
Postgresql has a translate function:

​Did you read the ( quoted at the bottom of the reply you sent ) message you were replying to? It contained a working sample using exactly this translate.​ ;-> 

You would then need a little further processing to determine the tens, hundreds, etc.

I'll leave that to you to work out, but additional functions of
strpos(string, substring)
substr(string, from [, count])
length(string)

​Do not forget replace, shorter, easier.

Francisco Olarte.​



pgsql-general by date:

Previous
From: Willy-Bas Loos
Date:
Subject: epoch and timezone changed bevior
Next
From: Vik Fearing
Date:
Subject: Re: epoch and timezone changed bevior