DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=c9CENcGhoXB4h6JttsXLxMMgPaB2rsQnqcjxhoWw/KLtT79nolUVc6HEBZ7hjnLzPO415hysvcvLLp/rvBS0y0b9py8V3g6SZBwmGpiaz2F2aucZfzx5QUla+MGWrQGlpFwPsHixrwogyiBS8C0k03iigfKbixMOCkng0aUrcUs=
Message-ID: <6d8daee30507191200ca398d1@mail.gmail.com>
Date: Tue, 19 Jul 2005 12:00:21 -0700
From: Tony Wasson <ajwasson@gmail.com>
Reply-To: Tony Wasson <ajwasson@gmail.com>
To: John Kopanas <john.kopanas@protoseinc.com>
Subject: Re: funstions for parsing words
Cc: pgsql-sql@postgresql.org
In-Reply-To: <1DFC0740-7EF9-4104-BDDF-C1436453EF33@protoseinc.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <1DFC0740-7EF9-4104-BDDF-C1436453EF33@protoseinc.com>

On 7/19/05, John Kopanas <john.kopanas@protoseinc.com> wrote:
> 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:
>=20
>=20
> Phrases:
> ------------
> "Hello World"
> "Goodbye World"
> "I like candy
>=20
> Words (select statement result):
> ------------
> "Hello"
> "World"
> "Goodbye"
> "I"
> "Like"
> "Candy"
>=20
> Is anything like this possible?
>=20
> Thanks alot.
>=20
> Your Friend,
>=20
> John Kopanas

You can do this by using array_to_string and using a space as your
delimiter. If you need to trim the quotes use the trim function also.

You can also see the split_on_commas example below -- you'd want to
split on a space. I would also rewrite this to use array_to_string or
use pl/perl if you can.

http://archives.postgresql.org/pgsql-sql/2005-05/msg00204.php

Hope this helps.
Tony Wasson