Text search language field

Поиск
Список
Период
Сортировка
Искать
От
Daniel Staal
Тема
Text search language field
Дата
в 21:09:27
Msg-id
83D1A28F3F422F2F9D8C73BD@mac-pro.magehandbook.com
Список
Дерево обсуждения
Text search language field Daniel Staal <DStaal@usa.net>
Re: Text search language field Daniel Staal <DStaal@usa.net>
Re: Text search language field Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: Text search language field Daniel Staal <DStaal@usa.net>
Re: Text search language field Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: Text search language field Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: Text search language field Daniel Staal <DStaal@usa.net>

I'm working on project with some large text areas that will need to be 
searched, and I'm trying to set up an indexed text search field to make 
things a bit smoother.  Only one of the top requirements is that this has 
to be multi-lingual, so I should be using the correct language's text 
search.  The table stores the language the text is in, so in theory this 
should be easy...  But it seems to be a bit more subtle than it first 
appears.  Any ideas on the best way to set this up?

Tables:

Resource:
    "text_element"	text,
    "text_search"	tsvector,
    "language"		char varying(3) references "languages"

languages  (This is 'static' list of ISO 639-3 codes, to make sure 
everything uses the same codes):
    "code" character varying(3) primary key,
    "description" character varying(100)

Trigger (This is my first draft):
create trigger "textsearch_trig" before update or insert
   on "resource" for each row execute procedure
   tsvector_update_trigger_column("text_search", "language", 
"text_element");

The trigger currently throws an error 'column "language" is not of 
regconfig type' whenever I try to use it, and I'm looking for the best way 
to solve that.  The 'simple' solution of 'create text search configuration 
eng ( copy = pg_catalog.english );' didn't work.  Before I start into a 
long exploration into why and what should be done about it, I thought I'd 
seek wisdom.  ;)

Daniel T. Staal

---------------------------------------------------------------
This email copyright the author.  Unless otherwise noted, you
are expressly allowed to retransmit, quote, or otherwise use
the contents for non-commercial purposes.  This copyright will
expire 5 years after the author's death, or in 30 years,
whichever is longer, unless such a period is in excess of
local copyright law.
---------------------------------------------------------------
В списке pgsql-novice по дате отправления
От: Benjamin Hurt
Дата:
От: Daniel Staal
Дата:
Сообщение: Re: Text search language field
FAQ