在最后出现'- '或'|'后截断字符串

I'm using Postgres and would like to remove everything after the last occurrence of '- ' or '|'. this is the query I came up with:I'm using Postgres and would like to remove eve