Re: [BUGS] BUG #4887: inclusion operator (@>) on tsqeries behaves not conforming to documentation

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Alexey Bashtanov <bashtanov(at)imap(dot)cc>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Teodor Sigaev <teodor(at)sigaev(dot)ru>
Subject: Re: [BUGS] BUG #4887: inclusion operator (@>) on tsqeries behaves not conforming to documentation
Date: 2010-02-24 18:11:10
Message-ID: 201002241811.o1OIBAR19912@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers


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(at)imap(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do
+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2010-02-24 19:45:34 Re: to_timestamp error handling.
Previous Message Tom Lane 2010-02-24 17:41:53 Re: BUG #4921: ltree @> ltree[] operator shouldn't fail if ltree[] is empty

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2010-02-24 18:12:47 Re: A thought on Index Organized Tables
Previous Message Josh Berkus 2010-02-24 18:07:48 Re: pg_stop_backup does not complete