Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group