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@xxxxxxxxx> wrote:
--On Wed, Sep 19, 2018 at 6:34 AM Gabriel Furstenheim Milerud <furstenheim@xxxxxxxxx> 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.34If so, then (conceptually) does this work?SELECT replace(replace(my_numeric_string, user_thousand_sep, ''),user_decimal_sep, system_decimal_sep)::numericOr maybe I'm missing something about this!
Cheers,
KenAGENCY SoftwareA Free Software data systemBy and for non-profits(253) 245-3801learn more about AGENCY orfollow the discussion.