From: | Sukuchha <shreshai(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Multilingual full text indexing |
Date: | 2010-12-13 14:02:53 |
Message-ID: | 1292248973746-3303131.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a table ( named test) with following strucuture
ID, lang, Name, Name_en, Name_de
http://postgresql.1045698.n5.nabble.com/file/n3303131/Capture.jpg
I want to do a full text seach on the table. I can create a ts_vector and
store in another column by gin_tsvector = tsvector('de', Titel_de) ||
tsvector('en' Titel_en) . But my problem is that when i want to select and
display the column Name_en if the text is being entered in english language.
How can i select column based on the text being entered?
select id,(???????) from test where gin_tsvector @@ to_tsquery ('english',
'Ivalo Airport')
For example, if user entered Ivalo Airport, i want to select column Name_en
and if user entered Flughafen Ivalo, i want to select column Name_de.
Any help would be highly appreciated !
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Multilingual-full-text-indexing-tp3303131p3303131.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Devart | 2010-12-13 14:27:10 | Devart ADO.NET Data Providers Deliver Advanced Model-First and Database-First Support and Improved ORM Solution! |
Previous Message | Vick Khera | 2010-12-13 13:56:12 | Re: Problem while pg_xlog directory |