From: | Andreas Kraftl <andreas(dot)kraftl(at)kraftl(dot)at> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Fulltext index |
Date: | 2008-11-08 08:44:17 |
Message-ID: | 1226133857.9831.7.camel@zeus |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Gerhard Heift | 2008-11-08 09:12:45 | Get interval in months |
Previous Message | Andreas Kretschmer | 2008-11-08 08:44:16 | Re: Defining string to represent null values in select |