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?
Date: Thu, 8 Jul 2010 02:44:11 +0400 (MSD)
Message-ID: <Pine.LNX.4.64.1007080243370.32129@sn.sai.msu.ru> (raw)
In-Reply-To: <AANLkTimyzy0PZpnqAraoymmVnNBOZlFtFDWtAP9n5ADS@mail.gmail.com>
References: <AANLkTimyzy0PZpnqAraoymmVnNBOZlFtFDWtAP9n5ADS@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: oleg@sai.msu.su, pjkoczan@gmail.com
Subject: Re: tsearch2 and wildcards/pattern matching?
In-Reply-To: <Pine.LNX.4.64.1007080243370.32129@sn.sai.msu.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox