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

Partial substrings in FTS

From: A J <s5aly(at)yahoo(dot)com>
To: PG Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Partial substrings in FTS
Date: 2012-04-23 17:10:10
Message-ID: 1335201010.30117.YahooMailNeo@web161501.mail.bf1.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
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.

Thanks.

Responses

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2012-04-23 18:45:19
Subject: Re: Partial substrings in FTS
Previous:From: Greg CaultonDate: 2012-04-23 16:05:01
Subject:

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