Remove trailing '.0' only postgresql

Question

I am removing part of a string in my column customer_id in Postgresql.

Customer_id : 

N12300 
245007.00 


UPDATE public.meltuniverse SET customer_id=trim(trailing '.0' FROM customer_id::varchar);

I only want to remove the .00 at the end and now it returns me :

N123
245007

How i can fix this?

klin · Accepted Answer · 2019-12-06 04:56:50Z

2

UPDATE public.meltuniverse 
SET customer_id = regexp_replace(customer_id, '\.00$', '')

The pattern '\.00$' matches exact substring '.00' at the end of the string.

answered Dec 6, 2019 at 4:56

klin

123k15 gold badges241 silver badges263 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1