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

Oleg, Teodor, can you look at this?  I tried to fix it in wparser_def.c,
but couldn't figure out how.  Thanks.

---------------------------------------------------------------------------

Dan O'Hara wrote:
> 
> The following bug has been logged online:
> 
> Bug reference:      5021
> Logged by:          Dan O'Hara
> Email address:      danarasoftware@gmail.com
> PostgreSQL version: 8.3.7
> Operating system:   win32
> Description:        ts_parse doesn't recognize email addresses with
> underscores
> Details: 
> 
> In the following example, 
> 
> select distinct token as email 
> from ts_parse('default', ' first_last@yahoo.com '   )
> where tokid = 4
> 
> ts_parse returns last@yahoo.com rather than first_last@yahoo.com  It seems
> that any text prior to the underscore is truncated.  If the portion
> following the underscore is only numeric, such as this example,
> 
> select distinct token as email 
> from ts_parse('default', ' bill_2000@yahoo.com '   )
> where tokid = 4
> 
> then ts_parse returns nothing at all.
> 
> section 3.2.3 of RFC 5322 indicates that underscores are valid characters in
> an email address.
> 
> http://tools.ietf.org/html/rfc5322
> 
> -- 
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.comPG East:  http://www.enterprisedb.com/community/nav-pg-east-2010.do + If your life is a hard
drive,Christ can be your backup. +