Fulltext index

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

Responses

Browse pgsql-general by date

  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