Fulltext index
От | Andreas Kraftl |
---|---|
Тема | Fulltext index |
Дата | |
Msg-id | 1226133857.9831.7.camel@zeus обсуждение исходный текст |
Ответы |
Re: Fulltext index
Re: Fulltext index Re: Fulltext index |
Список | pgsql-general |
Hello again, my previous post wasn't answered. I think i told my question wrong :-). I have a table like a | b -------------------- 'de' | Hallo welt 'en' | Hello world How can I create a full text index over b? CREATE INDEX idx ON table USING gin( to_tsvector( case when a = 'de' then 'german' when a = 'en' then 'english' else 'english' end ), b); This doesn't work. Error Message in german: FEHLER: Zugriffsmethode »gin« unterstützt keine mehrspaltigen Indexe SQL state: 0A000 means, gin doesn't accept multicolumn indexes. Any ideas? Greetings Andreas -- Kraftl EDV - Dienstleistungen Linux, Linuxschulungen, Webprogrammierung Autofabrikstraße 16/6 1230 Wien
В списке pgsql-general по дате отправления: