Postgres Pro
Downloads
Home   >   mailing lists

Re: Partial substrings in FTS - Mailing list pgsql-admin

From Jesper Krogh
Subject Re: Partial substrings in FTS
Date
Msg-id 43E1596A-E8B7-4231-A236-B6B5C1C6299E@krogh.cc
Whole thread Raw
In response to Partial substrings in FTS  (A J <s5aly@yahoo.com>)
List pgsql-admin
Tree view

On 23/04/2012, at 19.10, A J <s5aly@yahoo.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

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Partial substrings in FTS
Next
From: Wells Oliver
Date:
Subject: Calling a plpgsql function with an array of results?