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"

KARASZI István · Accepted Answer · 2010-09-24 18:40:59Z

3

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

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

answered Sep 24, 2010 at 18:40

KARASZI István

31.5k9 gold badges106 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:23:59Z

0

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

edited May 23, 2017 at 12:23

CommunityBot

11 silver badge

answered Sep 24, 2010 at 18:40

burkestar

7771 gold badge4 silver badges12 bronze badges

Collectives™ on Stack Overflow

splitting strings in postgres

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related