splitting strings in postgres

Question

I have a string with some spaces in it, and would like to split on the last space, and return the part of the string before that space. Does Postgres support this? I have not been able to solve this with the usual split_part-type functions.
Example : "fort worth tx" -> "fort worth"

Answer 1

You'll need to write a plpgsql function to accomplish this. Look here for function to find last occurrence of string.

Answer 2

it does not split the source string, but does what you want:

SELECT regexp_replace('fort worth tx', '\\s\\S+$', '');