Обсуждение: Postgresql: Remove last char in text-field if the column ends with minus sign

Поиск

Список

Период

Сортировка

От

Sarang Dave

Дата:

16 декабря 2010 г., 13:16:38

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

От

Steve Crawford

Дата:

16 декабря 2010 г., 14:02:20

On 12/16/2010 06:52 AM, Sarang Dave wrote:

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?

regexp_replace(your_field, '-+$', '');

Cheers,
Steve