Josh Berkus <josh@agliodbs.com> writes:
> In regular text fields containing words, your problem is solvable with full
> text indexing (FTI). Unfortunately, FTI is not designed for arbitrary
> non-language strings. It could be adapted, but would require a lot of
> hacking.
I'm not sure why you say that FTI isn't a usable solution. As long as
the gene symbols are separated by whitespace or some other non-letters
(eg, "foo mif bar" not "foomifbar"), I'd think FTI would work.
regards, tom lane