title: splitting strings in postgres
body: <p>I have a string with some spaces in it, and would like to split on the <strong>last</strong> 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.<br>
  Example : "fort worth tx" -> "fort worth"</p>