funstions for parsing words

From: John Kopanas <john(dot)kopanas(at)protoseinc(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: funstions for parsing words
Date: 2005-07-19 17:11:31
Message-ID: 1DFC0740-7EF9-4104-BDDF-C1436453EF33@protoseinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tony Wasson 2005-07-19 19:00:21 Re: funstions for parsing words
Previous Message Andreas Joseph Krogh 2005-07-19 15:58:05 Re: echo/printf function in plpgsql