Обсуждение: strange behave of fulltext query when query contains negation of prefix

Поиск
Список
Период
Сортировка

strange behave of fulltext query when query contains negation of prefix

От
Pavel Stehule
Дата:
Hello all

I found little bit strange behave of query search when I try to use
negation of prefix

postgres=# select nazev from obce where to_tsvector('simple',nazev) @@
to_tsquery('simple','skalice');       nazev
----------------------Klášterní SkaliceStříbrná SkaliceSkaliceSkalice u České LípySkaliceČeská SkaliceSkalice nad
SvitavouSkalice
(8 rows)

Second result is without word "české, česká", and it is correct

postgres=# select nazev from obce where to_tsvector('simple',nazev) @@
to_tsquery('simple','skalice & !(česká | české)');       nazev
----------------------Klášterní SkaliceStříbrná SkaliceSkaliceSkaliceSkalice nad SvitavouSkalice
(6 rows)

but when I try to reduce query with prefix search, then I get unexpected result

postgres=# select nazev from obce where to_tsvector('simple',nazev) @@
to_tsquery('simple','skalice & !čes:*');nazev
-------
(0 rows)

It is expected??

Regards

Pavel