如果我正确地理解了您的问题，则您有一个字符串，首先要在某个分隔符上将其拆分，然后再查找

If I understand your question correctly you have a string and you're first splitting it on some separator and then afterwards finding the last element of the array and discarding the rest.

您可能会错过中间人并直接获得最后一个元素：

You could miss out the middle man and get the last element directly:

SELECT regexp_replace('foo bar baz', '^.* ', '')

结果：

baz