[BUGS] BUG #6327: Prefix full-text-search fails for hosts with complicated names

2011-12-05 Thread Marcin . Kasperski
The following bug has been logged on the website: Bug reference: 6327 Logged by: Marcin Kasperski Email address: marcin.kasper...@mekk.waw.pl PostgreSQL version: 9.1.1 Operating system: Linux Description: Synopsis = 'goog:*' matches google.com but 'e-goog:*

Re: [BUGS] BUG #6327: Prefix full-text-search fails for hosts with complicated names

2011-12-05 Thread Euler Taveira de Oliveira
On 05-12-2011 09:40, marcin.kasper...@mekk.waw.pl wrote: > 'goog:*' matches google.com > but > 'e-goog:*' does not match e-google.com > It is a known limitation. The text search parser ignores some uncommon cases. See TODO and archives. -- Euler Taveira de Oliveira - Timbira http://w

Re: [BUGS] BUG #6327: Prefix full-text-search fails for hosts with complicated names

2011-12-05 Thread Tom Lane
marcin.kasper...@mekk.waw.pl writes: > Synopsis > = > 'goog:*' matches google.com > but > 'e-goog:*' does not match e-google.com The reason for this seems to be that the pattern is treated as a hyphenated word: regression=# select TO_TSQUERY('english', 'e-goog:*'); to_tsquery

Re: [BUGS] BUG #6327: Prefix full-text-search fails for hosts with complicated names

2011-12-05 Thread Euler Taveira de Oliveira
On 05-12-2011 12:29, Marcin Kasperski wrote: >>> 'goog:*' matches google.com >>> but 'e-goog:*' does not match e-google.com >>> >> It is a known limitation. The text search parser ignores some uncommon cases. >> See TODO and archives. > > Could you suggest me what to look for? I don't see anythi

Re: [BUGS] possible bug seen with -DCLOBBER_CACHE_ALWAYS and changing GUCs

2011-12-05 Thread Jeff Davis
On Wed, Nov 30, 2011 at 5:10 PM, Tom Lane wrote: > The result of parse analysis for that query is a stored date constant > (in a Const node) with a cast-to-text on top of it.  The system is aware > that cast-date-to-text isn't immutable, so it doesn't try to fold the > cast operation.  When you ex

Re: [BUGS] possible bug seen with -DCLOBBER_CACHE_ALWAYS and changing GUCs

2011-12-05 Thread Tom Lane
Jeff Davis writes: > On Wed, Nov 30, 2011 at 5:10 PM, Tom Lane wrote: >> The result of parse analysis for that query is a stored date constant >> (in a Const node) with a cast-to-text on top of it. The system is aware >> that cast-date-to-text isn't immutable, so it doesn't try to fold the >> ca