Re: [GENERAL] TSearch queries with multiple languages

2009-02-13 Thread Ivan Sergio Borgonovo
On Fri, 13 Feb 2009 09:55:04 +0300 (MSK) Oleg Bartunov wrote: > contrib/btree_gin, which is under review for 8.4, will allow to > create composite index like (ts_config, tsvector), so queries > which specified ts_config (language) will uses this index. Grass Root protectionism of good programmer

Re: [GENERAL] TSearch queries with multiple languages

2009-02-12 Thread Oleg Bartunov
On Thu, 12 Feb 2009, Tom Lane wrote: Gordon Callan writes: Next we create an index on the ts_vector column: CREATE INDEX node_ts_body on node USING gin(ts_body); From the documentation, it seems this index will know what config each row has. No, actually the index doesn't know and doesn'

Re: [GENERAL] TSearch queries with multiple languages

2009-02-12 Thread Tom Lane
Gordon Callan writes: > Next we create an index on the ts_vector column: > CREATE INDEX node_ts_body on node USING gin(ts_body); > From the documentation, it seems this index will know what config each row > has. No, actually the index doesn't know and doesn't care. The tsvector representat

[GENERAL] TSearch queries with multiple languages

2009-02-12 Thread Gordon Callan
Greetings, I'm implementing full text search at our company, using Tsearch2 and have read Chapter 12 (FTS) numerous times and am still unclear about something. All our data is stored in Postgresql in Unicode. The data to be searched can be in a number of different languages. I plan to creat