Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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: underscore.patch.gz
Description: application/x-tar (399 bytes)

In response to

Responses

pgsql-hackers by date

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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group