BUG #11660: TSVector not returning partial match on word "out"
The following bug has been logged on the website:
Bug reference: 11660
Logged by: David Levy
Email address: david.g.levy@gmail.com
PostgreSQL version: 9.3.5
Operating system: Windows 8 and RH Linux
Description:
I'm guessing that "out" is some kind of internal reserved word - I can't
find any documentation on this so submitting a bug until it can be
clarified/specified behavior:
-- First example returns true.
select to_tsvector('monkey outbreak') @@ to_tsquery('mon:*');
-- Second example returns false (bug?)
select to_tsvector('monkey outbreak') @@ to_tsquery('out:*');
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
david.g.levy@gmail.com writes:
I'm guessing that "out" is some kind of internal reserved word - I can't
find any documentation on this so submitting a bug until it can be
clarified/specified behavior:
No, but it's listed in english.stop. Feel free to make a custom
stopword list if you don't like that.
regression=# select to_tsquery('mon:*');
to_tsquery
------------
'mon':*
(1 row)
regression=# select to_tsquery('out:*');
NOTICE: text-search query contains only stop words or doesn't contain lexemes, ignored
to_tsquery
------------
(1 row)
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs