Date: Thu, 8 Jul 2010 02:44:11 +0400 (MSD)
From: Oleg Bartunov <oleg@sai.msu.su>
To: Peter Koczan <pjkoczan@gmail.com>
cc: pgsql-sql@postgresql.org
Subject: Re: tsearch2 and wildcards/pattern matching?
In-Reply-To: <AANLkTimyzy0PZpnqAraoymmVnNBOZlFtFDWtAP9n5ADS@mail.gmail.com>
Message-ID: <Pine.LNX.4.64.1007080243370.32129@sn.sai.msu.ru>
References: <AANLkTimyzy0PZpnqAraoymmVnNBOZlFtFDWtAP9n5ADS@mail.gmail.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed

it's called prefix search:

=# select 'zvt123456'::tsvector @@ 'zvt:*';
  ?column? 
----------
  t


On Wed, 7 Jul 2010, Peter Koczan wrote:

> Hi all,
>
> Is there any sort of pattern matching or partial matching capability
> in tsearch2?
>
> I'd like to be able search for a common prefix (like for order
> numbers). For instance, tsearch2 will index 'zvt123456' or
> 'zvt555555', but I'd like to be able to find both of them in one query
> using something akin to 'zvt%', like
>
> select * from attachments where textsearchable @@ 'zvt%';
>
> I've been unable to find anything in documentation. If there's
> anything in tsearch2 that can do this and is faster than LIKE clauses
> on full-text, that would be fantastic.
>
> Cheers,
> Peter
>
>

 	Regards,
 		Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83