Re: Convert number to string

Поиск
Список
Период
Сортировка
От Francisco Olarte
Тема Re: Convert number to string
Дата
Msg-id CA+bJJbyioOUH80sa_HbdhyOR_+iVt1p4yMmYU=7pLM5iWoey0Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Convert number to string  (Melvin Davidson <melvin6925@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Willy-Bas Loos
Дата:
Сообщение: epoch and timezone changed bevior
Следующее
От: Vik Fearing
Дата:
Сообщение: Re: epoch and timezone changed bevior