Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux