Thread: Postgresql: Remove last char in text-field if the column ends with minus sign

Hello sir,

I want to remove the last char in a column if it ends with the minus sign. How could I do this in postgresql?

For example:

sdfs-dfg4t-etze45z5z- => sdfs-dfg4t-etze45z5z


gsdhfhsfh-rgertggh => stay untouched

Is there an easy syntax I can use?

Thanking You.

With Regards,
Sarang Dave