Re: [BUGS] BUG #5021: ts_parse doesn't recognize email addresses with underscores

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Dan O'Hara <danarasoftware(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Subject: Re: [BUGS] BUG #5021: ts_parse doesn't recognize email addresses with underscores
Date: 2010-02-26 20:12:25
Message-ID: 4B882B29.1070308@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

> Oleg, Teodor, can you look at this? I tried to fix it in wparser_def.c,
> but couldn't figure out how. Thanks.
>>
>> select distinct token as email
>> from ts_parse('default', ' first_last(at)yahoo(dot)com ' )
>> where tokid = 4

Patch in attachment, it allows underscore in the middle of local part of email
in in host name (similarly to '-' character).

I'm not sure about backpatching, because it could break existing search
configuration.
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

Attachment Content-Type Size
underscore.patch.gz application/x-tar 399 bytes

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Administrator 2010-02-27 00:12:10
Previous Message Alvaro Herrera 2010-02-26 19:32:51 Re: Diffrent column ordering after dump/restore tables with INHERITS

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-02-26 20:21:05 Re: Re: Hot Standby query cancellation and Streaming Replication integration
Previous Message Yeb Havinga 2010-02-26 20:11:16 Re: Avoiding bad prepared-statement plans.