Обсуждение: Re: [BUGS] 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.comPG 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 > 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 >
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