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

Reply via email to