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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general