Re: Converting to number with given format

Поиск
Список
Период
Сортировка
От Gabriel Furstenheim Milerud
Тема Re: Converting to number with given format
Дата
Msg-id CAJN3DWrtoy35jRsK3XWu85emzhCsQFjyDpHJ62wNMqH95fez2g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Converting to number with given format  (Ken Tanzer <ken.tanzer@gmail.com>)
Список pgsql-general
Дерево обсуждения
Hi Ken,
Thanks a lot, that's a cool idea and I think that it will cover my needs.

On Thu, 20 Sep 2018 at 02:04, Ken Tanzer <ken.tanzer@gmail.com> wrote:
On Wed, Sep 19, 2018 at 6:34 AM Gabriel Furstenheim Milerud <furstenheim@gmail.com> wrote:

Maybe that is not possible with numbers? To say in a format something like "my numbers have comma as decimal separator and no thousands separators" or "my numbers are point separated and have comma as thousands separator"


Would stripping out the thousand separator, and leaving in the decimal separator work?

SELECT replace('9,000.34',',','')::numeric;replace 
---------9000.34
If so, then (conceptually) does this work?
SELECT replace(
  replace(my_numeric_string, user_thousand_sep, ''),
  user_decimal_sep, system_decimal_sep
)::numeric

Or maybe I'm missing something about this!

Cheers,

Ken


--
AGENCY Software  
A Free Software data system
By and for non-profits
(253) 245-3801

learn more about AGENCY or
follow the discussion.

В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Travers
Дата:
Сообщение: Re: Code of Conduct
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Advice on machine specs for growth