tomas@xxxxxxxxxx wrote: > On Tue, Oct 31, 2006 at 08:55:04PM -0800, Joshua D. Drake wrote: > > > > >> We are not storing bytea [...] > [...] > > > Hmm, have you tried to create a functional trigram index on the > > > equivalent of "strings(bytea_column)" or something like that? > > Hrm. Sorry for my impolite interuption, but... is there such a thing as > a "functional trigram index"? (this would be very cool). Heh :-) I meant an index, using the pg_trgm opclass (which indexes trigrams; hence the "trigram" part), on a function that would extract the text from a bytea column; instead of indexing the trigrams of the bytea column directly. Hence the "functional" part. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
