Re: Splitting text into rows with SQL - Mailing list pgsql-sql

From Ryan
Subject Re: Splitting text into rows with SQL
Date
Msg-id 11314.65.102.128.233.1047074894.squirrel@fordparts.com
Whole thread Raw
In response to Splitting text into rows with SQL  (Chris Gamache <cgg007@yahoo.com>)
List pgsql-sql
> 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





pgsql-sql by date:

Previous
From: Chris Gamache
Date:
Subject: Splitting text into rows with SQL
Next
From: daniel alvarez
Date:
Subject: Atomicity of UPDATE, interchanging values in unique column