From: | Artur Zakirov <a(dot)zakirov(at)postgrespro(dot)ru> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | unexpected result from to_tsvector |
Date: | 2016-02-23 17:53:33 |
Message-ID: | 56CC9C9D.1050603@postgrespro.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello,
Here is a little patch. It fixes this issue
http://www.postgresql.org/message-id/20160217080048.26357.49416@wrigleys.postgresql.org
Without patch we get wrong result for the second email 'test(at)123-reg(dot)ro':
=> SELECT * FROM ts_debug('simple', 'test(at)vauban-reg(dot)ro');
alias | description | token | dictionaries | dictionary
| lexemes
-------+---------------+--------------------+--------------+------------+----------------------
email | Email address | test(at)vauban-reg(dot)ro | {simple} | simple |
{test(at)vauban-reg(dot)ro}
(1 row)
=> SELECT * FROM ts_debug('simple', 'test(at)123-reg(dot)ro');
alias | description | token | dictionaries | dictionary |
lexemes
-----------+------------------+--------+--------------+------------+----------
asciiword | Word, all ASCII | test | {simple} | simple | {test}
blank | Space symbols | @ | {} | |
uint | Unsigned integer | 123 | {simple} | simple | {123}
blank | Space symbols | - | {} | |
host | Host | reg.ro | {simple} | simple |
{reg.ro}
(5 rows)
After patch we get correct result for the second email:
=> SELECT * FROM ts_debug('simple', 'test(at)123-reg(dot)ro');
alias | description | token | dictionaries | dictionary |
lexemes
-------+---------------+-----------------+--------------+------------+----------------------
email | Email address | test(at)123-reg(dot)ro | {simple} | simple |
{test(at)123-reg(dot)ro}
(1 row)
This patch allows to parser work with emails 'test(at)123-reg(dot)ro',
'123(at)123-reg(dot)ro' and 'test(at)123_reg(dot)ro' correctly.
--
Artur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
Attachment | Content-Type | Size |
---|---|---|
number_in_email.patch | text/x-patch | 683 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2016-02-23 17:58:35 | Re: pg_export_snapshot on standby side |
Previous Message | Bruce Momjian | 2016-02-23 17:06:24 | Re: The plan for FDW-based sharding |