Re: [HACKERS] unexpected result from to_tsvector

2016-03-30 Thread Shulgin, Oleksandr
On Wed, Mar 30, 2016 at 10:17 AM, Artur Zakirov wrote: > On 29.03.2016 19:17, Shulgin, Oleksandr wrote: > >> >> Hm, indeed. Unfortunately, it is not quite easy to find "the" new RFC, >> there was quite a number of correcting and extending RFCs issued over >> the last

Re: [HACKERS] unexpected result from to_tsvector

2016-03-30 Thread Artur Zakirov
On 29.03.2016 19:17, Shulgin, Oleksandr wrote: Hm, indeed. Unfortunately, it is not quite easy to find "the" new RFC, there was quite a number of correcting and extending RFCs issued over the last (almost) 30 years, which is not that surprising... Are we going to do something about it? Is

Re: [HACKERS] unexpected result from to_tsvector

2016-03-29 Thread Shulgin, Oleksandr
On Sun, Mar 20, 2016 at 3:42 PM, Tom Lane wrote: > "Shulgin, Oleksandr" writes: > > On Mar 20, 2016 01:09, "Dmitrii Golub" wrote: > >> Alex, actually subdomain can start with digit, > > > Not according to the RFC you

Re: [HACKERS] unexpected result from to_tsvector

2016-03-25 Thread Artur Zakirov
On 25.03.2016 19:15, David Steele wrote: On 3/25/16 12:14 PM, Artur Zakirov wrote: On 25.03.2016 18:19, David Steele wrote: Hi Artur, On 3/20/16 10:42 AM, Tom Lane wrote: "Shulgin, Oleksandr" writes: On Mar 20, 2016 01:09, "Dmitrii Golub"

Re: [HACKERS] unexpected result from to_tsvector

2016-03-25 Thread David Steele
On 3/25/16 12:14 PM, Artur Zakirov wrote: On 25.03.2016 18:19, David Steele wrote: Hi Artur, On 3/20/16 10:42 AM, Tom Lane wrote: "Shulgin, Oleksandr" writes: On Mar 20, 2016 01:09, "Dmitrii Golub" wrote: Alex, actually subdomain can

Re: [HACKERS] unexpected result from to_tsvector

2016-03-25 Thread Artur Zakirov
On 25.03.2016 18:19, David Steele wrote: Hi Artur, On 3/20/16 10:42 AM, Tom Lane wrote: "Shulgin, Oleksandr" writes: On Mar 20, 2016 01:09, "Dmitrii Golub" wrote: Alex, actually subdomain can start with digit, Not according to the

Re: [HACKERS] unexpected result from to_tsvector

2016-03-25 Thread David Steele
Hi Artur, On 3/20/16 10:42 AM, Tom Lane wrote: "Shulgin, Oleksandr" writes: On Mar 20, 2016 01:09, "Dmitrii Golub" wrote: Alex, actually subdomain can start with digit, Not according to the RFC you have linked to. The

Re: [HACKERS] unexpected result from to_tsvector

2016-03-20 Thread Tom Lane
"Shulgin, Oleksandr" writes: > On Mar 20, 2016 01:09, "Dmitrii Golub" wrote: >> Alex, actually subdomain can start with digit, > Not according to the RFC you have linked to. The powers-that-be relaxed that some time ago; I assume there's a

Re: [HACKERS] unexpected result from to_tsvector

2016-03-20 Thread Shulgin, Oleksandr
On Mar 20, 2016 01:09, "Dmitrii Golub" wrote: > > 2016-03-14 16:22 GMT+03:00 Shulgin, Oleksandr < oleksandr.shul...@zalando.de>: >> >> In fact, the 123-yyy.zzz domain is not valid either according to the RFC (subdomain can't start with a digit), but since we already allow

Re: [HACKERS] unexpected result from to_tsvector

2016-03-19 Thread Artur Zakirov
I found the discussion about allowing an underscore in emails http://www.postgresql.org/message-id/200908281359.n7sdxfaf044...@wwwmaster.postgresql.org That bug report is about recognizing an underscore in the local part of an email. And is not about recognizing an underscore in a domain name.

Re: [HACKERS] unexpected result from to_tsvector

2016-03-19 Thread Dmitrii Golub
2016-03-14 16:22 GMT+03:00 Shulgin, Oleksandr : > On Mon, Mar 7, 2016 at 10:46 PM, Artur Zakirov > wrote: > >> Hello, >> >> On 07.03.2016 23:55, Dmitrii Golub wrote: >> >>> >>> >>> Hello, >>> >>> Should we added tests for this case? >>> >>

Re: [HACKERS] unexpected result from to_tsvector

2016-03-14 Thread Artur Zakirov
On 14.03.2016 16:22, Shulgin, Oleksandr wrote: Hm... now that doesn't look all that consistent to me (after applying the patch): =# select ts_debug('simple', 'a...@123-yyy.zzz'); ts_debug

Re: [HACKERS] unexpected result from to_tsvector

2016-03-14 Thread Shulgin, Oleksandr
On Mon, Mar 7, 2016 at 10:46 PM, Artur Zakirov wrote: > Hello, > > On 07.03.2016 23:55, Dmitrii Golub wrote: > >> >> >> Hello, >> >> Should we added tests for this case? >> > > I think we should. I have added tests for teo...@123-stack.net and > 1...@stack.net emails. >

Re: [HACKERS] unexpected result from to_tsvector

2016-03-10 Thread Dmitrii Golub
2016-03-08 0:46 GMT+03:00 Artur Zakirov : > Hello, > > On 07.03.2016 23:55, Dmitrii Golub wrote: > >> >> >> Hello, >> >> Should we added tests for this case? >> > > I think we should. I have added tests for teo...@123-stack.net and > 1...@stack.net emails. > > >>

Re: [HACKERS] unexpected result from to_tsvector

2016-03-07 Thread Artur Zakirov
Hello, On 07.03.2016 23:55, Dmitrii Golub wrote: Hello, Should we added tests for this case? I think we should. I have added tests for teo...@123-stack.net and 1...@stack.net emails. 123_reg.ro is not valid domain name, bacause of symbol "_"

Re: [HACKERS] unexpected result from to_tsvector

2016-03-07 Thread Dmitrii Golub
2016-02-23 20:53 GMT+03:00 Artur Zakirov : > Hello, > > Here is a little patch. It fixes this issue > http://www.postgresql.org/message-id/20160217080048.26357.49...@wrigleys.postgresql.org > > Without patch we get wrong result for the second email 't...@123-reg.ro': > >

[HACKERS] unexpected result from to_tsvector

2016-02-23 Thread Artur Zakirov
Hello, Here is a little patch. It fixes this issue http://www.postgresql.org/message-id/20160217080048.26357.49...@wrigleys.postgresql.org Without patch we get wrong result for the second email 't...@123-reg.ro': => SELECT * FROM ts_debug('simple', 't...@vauban-reg.ro'); alias |