X-Original-To: pgsql-sql@postgresql.org
Received: from t-9.net (unknown [64.246.36.43])
	by postgresql.org (Postfix) with SMTP id 10861474E44
	for <pgsql-sql@postgresql.org>; Fri,  7 Mar 2003 19:07:49 -0500 (EST)
Received: (qmail 4646 invoked by uid 0); 7 Mar 2003 22:08:14 -0000
Received: from localhost (HELO seahat.com) (127.0.0.1)
	by localhost with SMTP; 7 Mar 2003 22:08:14 -0000
Received: from 65.102.128.233
	(SquirrelMail authenticated user snubber@seahat.com)
	by fordparts.com with HTTP; Fri, 7 Mar 2003 16:08:14 -0600 (CST)
Message-ID: <11314.65.102.128.233.1047074894.squirrel@fordparts.com>
Date: Fri, 7 Mar 2003 16:08:14 -0600 (CST)
Subject: Re: Splitting text into rows with SQL
From: "Ryan" <pgsql-sql@seahat.com>
To: <pgsql-sql@postgresql.org>
X-Priority: 3
Importance: Normal
X-Mailer: SquirrelMail (version 1.2.8)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Archive-Number: 200303/210
X-Sequence-Number: 12250

> Using Postgresql 7.2.3 ...
>
> In order to search using indexes I need to split a composite field
> into its components and return it as rows...
<-SNIP->
> any ideas for creating my fictional "split" function? I don't mind if
> the solution is head-slapping-ly simple. I'm too close to the problem
> and can't seem to figure it out!
>
> CG
Take a look at contrib/fulltextindex/README.fti folder in the source
dist.

This should do exactly what you need.

Ryan