| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com> |
| Cc: | Henrik Zagerholm <henke(at)mac(dot)se>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org, oleg(at)sai(dot)msu(dot)su |
| Subject: | Re: Let's play bash the search engine |
| Date: | 2006-12-19 09:02:49 |
| Message-ID: | 20061219090249.GE9627@svr2.hagander.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Dec 19, 2006 at 01:48:22PM +0530, Gurjeet Singh wrote:
> On 12/19/06, Henrik Zagerholm <henke(at)mac(dot)se> wrote:
> >
> >Hello,
> >
> >Searching after "tsearch"
> >5. PostgreSQL: Documentation: Manuals: PostgreSQL 7.4: Examples [0.1]
> >...tsearch and tsearch2Full text
> >indexingPrevHomeNextLimitationsUpPage Files User Comments No comments
> >could be found for this...
> >http://www.postgresql.org/docs/7.4/interactive/examples.html
> >
> >Searching after "tsearch2"
> >An error occured while searching.
> >
> >Searching after "tsearch2full"
> >An error occured while searching.
>
>
> This error can be generalized to the reg-ex [::alpha::]+[::digit::]+
> Examples:
> A1
> A2 etc...
>
> Why is it so? =)
Seems to_tsvecto() returns NULL for tsearch2 or for, as you say,
anything that ends in a digit.
Oleg, can you comment on why this is happening? What can we do to fix
that?
//Magnus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Csaba Nagy | 2006-12-19 09:27:10 | Re: Second attempt, roll your own autovacuum |
| Previous Message | Magnus Hagander | 2006-12-19 08:58:44 | Re: Let's play bash the search engine |