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: (view raw, whole thread or download thread mbox)
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.



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

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