tsearch2 match substrings

From: Abbath <abbath(at)invitel(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: tsearch2 match substrings
Date: 2006-03-03 13:57:04
Message-ID: 00d701c63eca$5c5b96e0$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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sascha Nepper 2006-03-03 14:20:00 Re: ERROR: column "datpath" does not exist
Previous Message Muller Zsolt 2006-03-03 13:53:58 tsearch2 match substrings in words