| Lists: | pgsql-bugs |
|---|
| From: | david(dot)g(dot)levy(at)gmail(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #11660: TSVector not returning partial match on word "out" |
| Date: | 2014-10-13 00:47:42 |
| Message-ID: | 20141013004742.25461.98283@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 11660
Logged by: David Levy
Email address: david(dot)g(dot)levy(at)gmail(dot)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:*');
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | david(dot)g(dot)levy(at)gmail(dot)com |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #11660: TSVector not returning partial match on word "out" |
| Date: | 2014-10-13 14:04:41 |
| Message-ID: | 31595.1413209081@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
david(dot)g(dot)levy(at)gmail(dot)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