Re: Let's play bash the search engine

On Tue, Dec 19, 2006 at 01:48:22PM +0530, Gurjeet Singh wrote:
> On 12/19/06, Henrik Zagerholm <henke@mac.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