Oleg, Teodor, would you look at this? I see the same behavior in 9.0.
---------------------------------------------------------------------------
Alexey Bashtanov wrote:
>
> The following bug has been logged online:
>
> Bug reference: 4887
> Logged by: Alexey Bashtanov
> Email address: bashtanov@imap.cc
> PostgreSQL version: 8.3.1, 8.3.7
> Operating system: Linux 2.6.20 FC5 i686, Linux 2.6.27 FC10 i686
> Description: inclusion operator (@>) on tsqeries behaves not
> conforming to documentation
> Details:
>
> Hello!
>
> '!a|b'::tsquery <@ 'a|b'::tsquery evaluates to false, but should evalueate
> to true
> (http://www.postgresql.org/docs/8.3/interactive/functions-textsearch.html
> says "The tsquery containment operators consider only the lexemes listed in
> the two queries, ignoring the combining operators.")
>
> I think negation operator is treated as a lexeme. So please correct the
> behaviour of operators or rewrite this line of docs.
>
> Thanks,
> Alexey
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.comPG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do + If your life is a hard
drive,Christ can be your backup. +