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

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.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. +

On Wed, Feb 24, 2010 at 2:11 PM, Bruce Momjian <bruce@momjian.us> wrote:

Oleg, Teodor, would you look at this?  I see the same behavior in 9.0.

As there has been no movement on this I think we should punt this from:

http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items

to

http://wiki.postgresql.org/wiki/Todo

...Robert

Robert Haas wrote:

On Wed, Feb 24, 2010 at 2:11 PM, Bruce Momjian <bruce@momjian.us> wrote:

Oleg, Teodor, would you look at this? ?I see the same behavior in 9.0.

As there has been no movement on this I think we should punt this from:

http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items

to

http://wiki.postgresql.org/wiki/Todo

Agreed, though I am disappointed because I thought Oleg and Teodor were
going to look at this bug.

---------------------------------------------------------------------------

...Robert

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.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. +

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

On Tue, Apr 20, 2010 at 12:27 PM, Bruce Momjian <bruce@momjian.us> wrote:

Robert Haas wrote:

On Wed, Feb 24, 2010 at 2:11 PM, Bruce Momjian <bruce@momjian.us> wrote:

Oleg, Teodor, would you look at this? ?I see the same behavior in 9.0.

As there has been no movement on this I think we should punt this from:

http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items

to

http://wiki.postgresql.org/wiki/Todo

Agreed, though I am disappointed because I thought Oleg and Teodor were
going to look at this bug.

Moved.

...Robert