Fulltext: problem with english words in german text

From: Torsten Zühlsdorff <foo(at)meisterderspiele(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Fulltext: problem with english words in german text
Date: 2009-03-24 09:19:44
Message-ID: gqa8jk$m87$1@news.motzarella.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

i have a problem with understanding fulltext search in PG 8.3.

Example:

CREATE TABLE tfulltext (body text, fulltext tsvector);

INSERT INTO tfulltext VALUES ('title und description sind wichtige
grundlagen', to_tsvector('pg_catalog.german', 'title und description
sind wichtige grundlagen'));

SELECT * from tfulltext;
body |
fulltext
------------------------------------------------+---------------------------------------------------
title und description sind wichtige grundlagen | 'titl':1 'wichtig':5
'grundlag':6 'description':3

I expect, that the query:
SELECT * FROM tfulltext WHERE fulltext @@ to_tsquery('title');

Will return the entry. But the result-set is empty. If i use 'titl'
(without 'e') as parameter of to_tsquery it returns the entry.

I try to cast the search-parameter to ts_vector, but it didn't work. How
can i solve the problem?

Thanks for every hint and greetings from Germany,
Torsten
--
http://www.dddbl.de - ein Datenbank-Layer, der die Arbeit mit 8
verschiedenen Datenbanksystemen abstrahiert,
Queries von Applikationen trennt und automatisch die Query-Ergebnisse
auswerten kann.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Torsten Zühlsdorff 2009-03-24 09:23:43 Re: Fulltext: problem with english words in german text
Previous Message josep porres 2009-03-24 07:50:05 Re: debugging in pgadmin