Re: Splitting text into rows with SQL

From: "Ryan" <pgsql-sql(at)seahat(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Splitting text into rows with SQL
Date: 2003-03-07 22:08:14
Message-ID: 11314.65.102.128.233.1047074894.squirrel@fordparts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Gamache 2003-03-07 22:14:01 Splitting text into rows with SQL
Previous Message Achilleus Mantzios 2003-03-07 20:14:39 Hex Integer Input