funstions for parsing words - Mailing list pgsql-sql

I have a table called Phrases that holds the text of a phrase. I want
write a query that will return all the words found in all the text of
the Phrases. Like so:


Phrases:
------------
"Hello World"
"Goodbye World"
"I like candy

Words (select statement result):
------------
"Hello"
"World"
"Goodbye"
"I"
"Like"
"Candy"

Is anything like this possible?

Thanks alot.

Your Friend,

John Kopanas