]> wagnertech.de Git - kivitendo-erp.git/blob - sql/Pg-upgrade2/bank_transactions_nuke_trailing_spaces_in_purpose.sql
Merge tag 'kivitendo_3.5.4-2' into b-3.5.6.1
[kivitendo-erp.git] / sql / Pg-upgrade2 / bank_transactions_nuke_trailing_spaces_in_purpose.sql
1 -- @tag: bank_transactions_nuke_trailing_spaces_in_purpose
2 -- @description: Banktransaktionen: überflüssige Leerzeichen am Ende des Verwendungszwecks entfernen
3 -- @depends: release_3_5_4
4 UPDATE bank_transactions
5 SET purpose = regexp_replace(purpose, ' +$', '')
6 WHERE purpose ~ ' +$';