[GENERAL] Fulltext: problem with english words in german text

2009-03-24 Thread Torsten Zühlsdorff
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 grundlag

Re: [GENERAL] Fulltext: problem with english words in german text

2009-03-24 Thread Torsten Zühlsdorff
[..] I've just noticed, that i forgot to change the subject. While writing i figured out, that the question is not the one, i want to ask. I am sorry for confusions. Greetings, Torsten -- http://www.dddbl.de - ein Datenbank-Layer, der die Arbeit mit 8 verschiedenen Datenbanksystemen abstrahi

Re: [GENERAL] Fulltext: problem with english words in german text

2009-03-24 Thread Torsten Zühlsdorff
Torsten Zühlsdorff schrieb: Hello, i have a problem with understanding fulltext search in PG 8.3. [..] I solved it. I have to specify the language in to_tsquery(). -.- Greetings, Torsten -- http://www.dddbl.de - ein Datenbank-Layer, der die Arbeit mit 8 verschiedenen Datenbanksystemen abstr