Re: Partial substrings in FTS

From: Jesper Krogh <jesper(at)krogh(dot)cc>
To: A J <s5aly(at)yahoo(dot)com>
Cc: PG Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Partial substrings in FTS
Date: 2012-04-23 18:53:42
Message-ID: 43E1596A-E8B7-4231-A236-B6B5C1C6299E@krogh.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On 23/04/2012, at 19.10, A J <s5aly(at)yahoo(dot)com> wrote:

> In FTS, how do I search for partial substrings that don't form a English word.
> Example, in the text: 'one hundred thirty four' I want to find the records based on 'hun'
>
> SELECT to_tsvector('one hundred thirty four') @@ to_tsquery('hun');
> does not return anything.

Try to_tsquery('hun:*')

Jesper

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2012-04-24 00:29:47 Calling a plpgsql function with an array of results?
Previous Message Kevin Grittner 2012-04-23 18:45:19 Re: Partial substrings in FTS