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(at)gmail(dot)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(at)yahoo(dot)com ' )
> where tokid = 4
>
> ts_parse returns last(at)yahoo(dot)com rather than first_last(at)yahoo(dot)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(at)yahoo(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

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