Postgres Pro
Downloads
Home   >   mailing lists

Re: tsearch2 and wildcards/pattern matching? - Mailing list pgsql-sql

From Peter Koczan
Subject Re: tsearch2 and wildcards/pattern matching?
Date
Msg-id AANLkTils9YaZKkPhyPthZl551aigQjf-zWJ8lqQEjgu2@mail.gmail.com
Whole thread Raw
In response to Re: tsearch2 and wildcards/pattern matching?  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-sql
Tree view 
On Wed, Jul 7, 2010 at 5:44 PM, Oleg Bartunov <oleg@sai.msu.su> wrote:
> it's called prefix search:
>
> =# select 'zvt123456'::tsvector @@ 'zvt:*';
>  ?column? ----------
>  t

Ah, that works. Excellent.

Thanks,
Peter

pgsql-sql by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: tsearch2 and wildcards/pattern matching?
Next
From: Viktor Bojović
Date:
Subject: Re: strangest thing happened