[BUGS] BUG #14552: tsquery converts AND operator into OR when nested insideOR operations

Поиск
Список
Период
Сортировка
От bjorn@eventmy.com
Тема [BUGS] BUG #14552: tsquery converts AND operator into OR when nested insideOR operations
Дата
Msg-id 20170218003621.6098.76708@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: [BUGS] BUG #14552: tsquery converts AND operator into OR when nested inside OR operations  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14552
Logged by:          Bjorn Linder
Email address:      bjorn@eventmy.com
PostgreSQL version: 9.4.5
Operating system:   OS 10.11.6
Description:

Working correctly, no results: 
SELECT ts_rank(to_tsvector('lets eat a cat'), ('fat & bat | rat'::tsquery &&
'cat'::tsquery));
 ts_rank
---------
   1e-20
(1 row)

Should also yield no results:
SELECT ts_rank(to_tsvector('lets eat a fat cat'), ('fat & bat |
rat'::tsquery && 'cat'::tsquery));
  ts_rank
-----------
 0.0991032
(1 row)

Is this intended behavior? Is there a recommended way to nest AND operators
inside OR operations? The relevant documentation looks to be the same for
newer versions so I'm assuming this behavior hasn't been changed between
versions - let me know. Thanks!


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Linas Vepstas
Дата:
Сообщение: Re: [BUGS] BUG #14494: Regression - Null arrays are not queryable
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [BUGS] BUG #14494: Regression - Null arrays are not queryable