PgSQL problem: How to split strings into rows
| От | Kynn Jones |
|---|---|
| Тема | PgSQL problem: How to split strings into rows |
| Дата | |
| Msg-id | c2350ba41001211049u51c82ff3wffe564add4f8188b@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: PgSQL problem: How to split strings into rows
Re: PgSQL problem: How to split strings into rows Re: PgSQL problem: How to split strings into rows |
| Список | pgsql-general |
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.)
TIA!
~K
В списке pgsql-general по дате отправления: