Re: PgSQL problem: How to split strings into rows

Kynn Jones wrote on 21.01.2010 19:49:
> I have a table X with some column K consisting of whitespace-separated
> words. Is there some SELECT query that will list all these words (for
> the entire table) so that there's one word per row in the returned
> table? E.g. If the table X is
>
> K
> ---------------------
> foo bar baz
> quux frobozz
> eeny meeny
> miny moe
>
> ...I want the result of this query to be
>
> foo
> bar
> baz
> quux
> frobozz
> eeny
> meeny
> miny
> moe
>
> How can I do this? (I have a slight preference for solutions that will
> work with version 8.2, but I'm interested in any solution to the problem.)
>

Don't know if this will work with 8.3:

select regexp_split_to_table(k, ' ')
from x;

Thomas