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