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 l
sometimes resume,
sometomes both.
Oleg Bartunov wrote:
>
> 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
gt;
> 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
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
Is it possible to have 2 gin indexes and OR the search of them?
Problem is, I need to search 5 columns and there is limitation of only 4
weights, so I want to have one index of 4 vectors and second index of 1
vector and need to OR the search.
When I try to search them separately, or use AND, it w
I've a table with tsvector column named meta_vector. Over this column there
is a gin index. When I execute query like:
select id from theses where meta_vector @@@ to_tsquery('cs', 'foo | (!bar)')
I get an errror message: query requires full scan, which is not supported by
GIN indexes.
The weird
