tsearch2 match substrings in words

From: "Muller Zsolt" <mzsolt(at)lionis(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: tsearch2 match substrings in words
Date: 2006-03-03 13:53:58
Message-ID: 00bf01c63ec9$ec2bcd40$3b00a8c0@abbath
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Is it possible using tsearch2 to match a substring of an element of a ts_vec
column?

For example: I have a table with a ts_vec, and I have a field with text, and
if there is a value in the field "I would like to match the beginning of the
words" - and the ts_vec has " 'like':3 'match':5 'begin':7 ...etc" then it
would be cool to create a query, which give me a headline for "begin" if I
just use the "beg" (or "beg*" ) search expression.

Is there a way to solve this?

Thanks in advance.

Abbath

Browse pgsql-general by date

  From Date Subject
Next Message Abbath 2006-03-03 13:57:04 tsearch2 match substrings
Previous Message Bart Golda 2006-03-03 13:35:04 Quick psqlODBC driver setting