Re: OK, does anyone have any better ideas?

Andrew Snow wrote:
> 
> Could you perhaps post the code you have for splitting a text field up into
> keys, then I could work on turning into a new type of index with a new
> operator, as Tom suggested?
> 
> (Or is this already what the text search code in contrib already does??)

I think that splitting the text is the least of the problems.

I've been contemplating integrating my own (currently BSDDB based) 
full-text-index with postgresql and I've come to the conclusion that 
the index proper should work on already split list-of-words (so it could
be 
made to work with any array types easily)

So my suggestion is to start working on an inverted-index on a field of
any 
array type.

Or even better - start digging in the indexing interface of PostgreSQL
first 
documenting it (the current docs just state that it is too complicated
for 
anyone to comprehend ;) and then cleaning it up and making it thus
making 
it easyer for any kind of new index to be written.

-------------
Hannu