Re: [GENERAL] Fulltext - multiple single column indexes

2009-03-21 Thread Oleg Bartunov
On Fri, 20 Mar 2009, esemba wrote: Thanks, this works quite fine, but I've ran into some problems so far: - It's not possible to specify more than 4 labels (just ABCD) this is well known limitation and we are certainly should think about it - In query I have to specify searched vectors for

Re: [GENERAL] Fulltext - multiple single column indexes

2009-03-21 Thread esemba
Ok, so what solution for the 4 column limitation would you suggest? I'll probably create two four-column indexes and OR search over them. Oleg Bartunov wrote: On Fri, 20 Mar 2009, esemba wrote: Thanks, this works quite fine, but I've ran into some problems so far: - It's not possible

Re: [GENERAL] Fulltext - multiple single column indexes

2009-03-20 Thread Oleg Bartunov
On Thu, 19 Mar 2009, esemba wrote: Hi, I have table with several columns and need to perform fulltext search over volatile number of columns. I can't use multicolumn gist index or gin index over concatenated columns, so I've created several single column indexes (one for each column I want to

Re: [GENERAL] Fulltext - multiple single column indexes

2009-03-20 Thread Richard Huxton
esemba wrote: Hi, I have table with several columns and need to perform fulltext search over volatile number of columns. I can't use multicolumn gist index or gin index over concatenated columns, so I've created several single column indexes (one for each column I want to search) and now I

Re: [GENERAL] Fulltext - multiple single column indexes

2009-03-20 Thread esemba
Well, thank you both for response, but I'm not sure, I understand Oleg's solution. This would work, but where is the variability of searched columns? In your example, I create new indexed column with concatenated vectors of 2 columns. But I sometimes new to search only annotation, sometimes

Re: [GENERAL] Fulltext - multiple single column indexes

2009-03-20 Thread Oleg Bartunov
On Fri, 20 Mar 2009, esemba wrote: Well, thank you both for response, but I'm not sure, I understand Oleg's solution. This would work, but where is the variability of searched columns? In your example, I create new indexed column with concatenated vectors of 2 columns. But I sometimes new to

Re: [GENERAL] Fulltext - multiple single column indexes

2009-03-20 Thread esemba
Thanks, this works quite fine, but I've ran into some problems so far: - It's not possible to specify more than 4 labels (just ABCD) - In query I have to specify searched vectors for each lexem. I think It would be better to specify searched vectors per-query. Oleg Bartunov wrote: On Fri, 20

[GENERAL] Fulltext - multiple single column indexes

2009-03-19 Thread esemba
Hi, I have table with several columns and need to perform fulltext search over volatile number of columns. I can't use multicolumn gist index or gin index over concatenated columns, so I've created several single column indexes (one for each column I want to search) and now I need to query them