Re: [BUGS] BUG #14515: tsquery with only a negative term doesn't match empty tsvector - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] BUG #14515: tsquery with only a negative term doesn't match empty tsvector
Date
Msg-id 30721.1485401548@sss.pgh.pa.us
Whole thread Raw
In response to [BUGS] BUG #14515: tsquery with only a negative term doesn't match emptytsvector  (pgsql@tomd.cc)
Responses Re: [BUGS] BUG #14515: tsquery with only a negative term doesn't match empty tsvector  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
pgsql@tomd.cc writes:
> Basically while `select 'somethingelse'::tsvector @@ '!foo'::tsquery`
> returns true, `select ''::tsvector @@ '!foo'::tsquery` returns false, which
> was surprising to me.

Not sure about this.  A plausible reading of '!foo' is "there is a lexeme
that is not foo".  But even if that was Oleg & Teodor's intention,
I would not want to swear that the tsquery stuff is totally consistent
about it ...

            regards, tom lane


-- 
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: pgsql@tomd.cc
Date:
Subject: [BUGS] BUG #14515: tsquery with only a negative term doesn't match emptytsvector
Next
From: andrew@tao11.riddles.org.uk
Date:
Subject: [BUGS] BUG #14516: misleading error from libpq on out-of-memory