From: | Marcin(dot)Kasperski(at)mekk(dot)waw(dot)pl |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #6327: Prefix full-text-search fails for hosts with complicated names |
Date: | 2011-12-05 12:40:10 |
Message-ID: | E1RXXq6-0000vH-BA@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 6327
Logged by: Marcin Kasperski
Email address: Marcin(dot)Kasperski(at)mekk(dot)waw(dot)pl
PostgreSQL version: 9.1.1
Operating system: Linux
Description:
Synopsis
=========
'goog:*' matches google.com
but
'e-goog:*' does not match e-google.com
Example SQL
=============
Try the queries below. Note ismatch column, which is t in the former, and f
in the latter case (IMHO should be t in both).
SELECT a query, b message, a@@b ismatch FROM (
SELECT TO_TSQUERY('english', 'goog:*') a,
TO_TSVECTOR('english', 'See google.com') b) as foo;
SELECT a query, b message, a@@b ismatch FROM (
SELECT TO_TSQUERY('english', 'e-goog:*') a,
TO_TSVECTOR('english', 'See e-google.com') b) as foo;
From | Date | Subject | |
---|---|---|---|
Next Message | Euler Taveira de Oliveira | 2011-12-05 15:02:24 | Re: BUG #6327: Prefix full-text-search fails for hosts with complicated names |
Previous Message | Noah Misch | 2011-12-05 06:23:52 | Re: possible bug seen with -DCLOBBER_CACHE_ALWAYS and changing GUCs |