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.
