split to table by space

Поиск
Список
Период
Сортировка
От Jamie Kahgee
Тема split to table by space
Дата
Msg-id da6bca21001021735g1382af1bu92c3197da5f54a0f@mail.gmail.com
обсуждение исходный текст
Ответы Re: split to table by space  (Brian Modra <epailty@googlemail.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Deadlocks On Demand
Следующее
От: Ivan K
Дата:
Сообщение: Re: Permission; select currval('seq')