Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-bugspgsql-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

pgsql-hackers by date

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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group