Re: Searching email, Full Text Search prefix, not expected results

But tsvector recognices email format as natural. And I'm not looking for a
substring. Please see the queries are incremental with the search string,
and see last four results ... I think some think it's no working properly.

El 14 de marzo de 2012 19:05, Daniel Vázquez <daniel2d2art(at)gmail(dot)com>escribió:

> Hi guys, I'm going to crazy about FTS with prefix agains email values on
> tsvector. Follow how to reproduce:
>
> For the next tsvector:
>
> =# select to_tsvector('user(at)company(dot)com')
> to_tsvector
> ----------------------
> 'user(at)company(dot)com':1
>
> I expects TRUE for all next tsqueryes:
>
> select to_tsvector('user(at)company(dot)com') @@ to_tsquery('u:*');
> select to_tsvector('user(at)company(dot)com') @@ to_tsquery('us:*');
> select to_tsvector('user(at)company(dot)com') @@ to_tsquery('use:*');
> select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user:*');
> select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user@:*');
> select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user(at)c:*');
> select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user(at)co:*');
> select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user(at)com:*');
> select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user(at)comp:*');
> select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user(at)compa:*');
> select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user(at)compan:*');
> select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user(at)company:*');
> select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user(at)company(dot):*');
> select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user(at)company(dot)c:*');
> select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user(at)company(dot)co:*');
> select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user(at)company(dot)com:
> *');
>
> But NOT, there are some NOT expected and confusing me results:
>
> =# select to_tsvector('user(at)company(dot)com') @@ to_tsquery('us:*');
> ?column?
> ----------
> t
> (1 row)
>
> =# select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user:*');
> ?column?
> ----------
> t
>
> =# select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user@:*');
> ?column?
> ----------
> t
>
> select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user(at)comp:*');
> ?column?
> ----------
> f <---- FALSE (I expects TRUE)
>
> =# select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user(at)company:*');
> ?column?
> ----------
> f <---- FALSE (I expects TRUE)
>
> =# select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user(at)company(dot)
> :*');
> ?column?
> ----------
> f <---- FALSE (I expects TRUE)
>
> =# select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user(at)company(dot)c
> :*');
> ?column?
> ----------
> f <---- FALSE (I expects TRUE)
>
> =# select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user(at)company(dot)co:
> *');
> ?column?
> ----------
> t <---- TRUE .... OOhhhhhHHH I'm going crazy!!!
>
> =# select to_tsvector('user(at)company(dot)com') @@ to_tsquery('user(at)company(dot)com:
> *');
> ?column?
> ----------
> t <---- TRUE ... Yes I'm crazy.
>
> Please some ligths about it.
> (I follow the official docs in
> http://www.postgresql.org/docs/9.1/interactive/textsearch.html for my
> knowledge)
>
> Thx!
>

--
Daniel Vázquez
SICONET (A Bull Group Company)
Torre Agbar. Avda. Diagonal, 211 - planta 23
08018 - Barcelona
telf: + 34 93 2272727 (Ext. 2952)
fax: + 34 93 2272728
www.bull.es - www.siconet.es
daniel(dot)vazquez(at)bull(dot)es