Hi all,
I have a text field which I'll be doing LIKE searches against so I
wanted to set up an index on it.
The data itself is too long to create a full index, so I can't just:
chris=> create index blah on ff_index(icontent);
ERROR: index row requires 21216 bytes, maximum size is 8191
So I thought I'd set up an index to use the first say 200 chars of the
string
chris=> create index blah on ff_index(substring(icontent, 0, 200));
ERROR: syntax error at or near "(" at character 40
I've tried many variations of this, same result.
I know I can create a partial index on it if the field is less than 200
chars, but that doesn't help me.
I'm running v7.4.5.
Any suggestions ?
Thanks,
Chris.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
