unexpected result from to_tsvector

Поиск
Список
Период
Сортировка
От Artur Zakirov
Тема unexpected result from to_tsvector
Дата
Msg-id 56CC9C9D.1050603@postgrespro.ru
обсуждение исходный текст
Ответы Re: unexpected result from to_tsvector  (Dmitrii Golub <dmitrii.golub@gmail.com>)
Список 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@123-reg.ro':

=> SELECT * FROM ts_debug('simple', 'test@vauban-reg.ro');
  alias |  description  |       token        | dictionaries | dictionary
|       lexemes
-------+---------------+--------------------+--------------+------------+----------------------
  email | Email address | test@vauban-reg.ro | {simple}     | simple  |
{test@vauban-reg.ro}
(1 row)

=> SELECT * FROM ts_debug('simple', 'test@123-reg.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@123-reg.ro');
  alias |  description  |      token      | dictionaries | dictionary |
       lexemes
-------+---------------+-----------------+--------------+------------+----------------------
  email | Email address | test@123-reg.ro | {simple}     | simple  |
{test@123-reg.ro}
(1 row)

This patch allows to parser work with emails 'test@123-reg.ro',
'123@123-reg.ro' and 'test@123_reg.ro' correctly.

--
Artur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] JDBC behaviour
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_export_snapshot on standby side