Postgres Pro
Downloads
Home   >   mailing lists

split to table by space - Mailing list pgsql-general

From Jamie Kahgee
Subject split to table by space
Date
Msg-id da6bca21001021735g1382af1bu92c3197da5f54a0f@mail.gmail.com
Whole thread Raw
Responses Re: split to table by space  (Brian Modra <epailty@googlemail.com>)
List pgsql-general
Tree view
I need a function like regexp_split_to_table where I can split a string to a table by a space delimiter.

so:

Please Help Me

would convert to:

Please
Help
Me

However I'm stuck working w/ version 8.2.9, so I don't have the regexp_split_to_table function. Is there any good functions that can handle this in my version that I am unaware of?  Or does anyone know how to write an easy function to handle this in in plpgsql or something? 

Thanks,
Jamie K.

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Deadlocks On Demand
Next
From: Ivan K
Date:
Subject: Re: Permission; select currval('seq')