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

[Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxxxxxx>]

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