When I said full text, I meant substring. Please correct me if I am wrong, but
tsearch would be useful for finding words in a paragraph, not characters in a
word (or small group of words) ... If I had fields 'Hello World!', 'Low Tide',
and 'Following Day' they would all be hits for a search on 'low' ...
Ok, I see
I bet you meant ltree/ltree.h ... I'll give that a try and see what happens!
Thank you!
Ltree index structure is mixed by BTree and signature tree. You don't need Btree
part as I understand...
I don't know efficient index structure to support queries you want... May be
Oleg knows...
--
Teodor Sigaev E-mail: teodor@xxxxxxxxx
WWW: http://www.sigaev.ru/