[BUGS] BUG #14552: tsquery converts AND operator into OR when nested insideOR operations - Mailing list pgsql-bugs

From bjorn@eventmy.com
Subject [BUGS] BUG #14552: tsquery converts AND operator into OR when nested insideOR operations
Date
Msg-id 20170218003621.6098.76708@wrigleys.postgresql.org
Whole thread Raw
Responses Re: [BUGS] BUG #14552: tsquery converts AND operator into OR when nested inside OR operations  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Linas Vepstas
Date:
Subject: Re: [BUGS] BUG #14494: Regression - Null arrays are not queryable
Next
From: "David G. Johnston"
Date:
Subject: Re: [BUGS] BUG #14494: Regression - Null arrays are not queryable