TO_TSVECTOR acts differently with national charcters

From: Mart Palmas <Mart(dot)Palmas(at)datel(dot)ee>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: TO_TSVECTOR acts differently with national charcters
Date: 2017-08-22 08:53:45
Message-ID: 2E9A0BD1BE1DDD498AD83A732B3EF884AD38A7AC@mail2.datel.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Query:

SELECT strip(to_tsvector('simple','toop/6 foo bar')),strip(to_tsvector('simple','tüüp/6 foo bar'));

PosgreSQL 9.3.5, Collation - Estonian

Results are:
'bar' 'foo' 'toop/6'
'/6' 'bar' 'foo' 'tüüp'

The string is converted to vector differently, when the string contains national charcters "äöüõžš".

Mart Palmas

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Wei Congrui 2017-08-22 14:39:16 Re: [BUGS] 直接执行psql.exe出现的问题
Previous Message Abhijit Gharami 2017-08-22 06:37:24 Re: [BUGS] Fwd: PostgreSQL 9.4.13 is facing issue in shutting down