Re: tsearch2 and wildcards/pattern matching?

From: Peter Koczan <pjkoczan(at)gmail(dot)com>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: tsearch2 and wildcards/pattern matching?
Date: 2010-07-08 01:51:24
Message-ID: AANLkTils9YaZKkPhyPthZl551aigQjf-zWJ8lqQEjgu2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, Jul 7, 2010 at 5:44 PM, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> wrote:
> it's called prefix search:
>
> =# select 'zvt123456'::tsvector @@ 'zvt:*';
>  ?column? ----------
>  t

Ah, that works. Excellent.

Thanks,
Peter

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Viktor Bojović 2010-07-08 06:36:35 Re: strangest thing happened
Previous Message Oleg Bartunov 2010-07-07 22:44:11 Re: tsearch2 and wildcards/pattern matching?