On Sat, 8 Nov 2008, Andreas Kraftl wrote:
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?
use concatenation operator: tsvector('de',b_de) || tsvector('en',b_en)
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
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@xxxxxxxxxx, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
