[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
|
| Список | 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 по дате отправления: