PROTECTED]
Subject: Re: [GENERAL] partial index on a text field
"Chris" <[EMAIL PROTECTED]> writes:
> chris=> create index blah on ff_index(substring(icontent, 0, 200));
> ERROR: syntax error at or near "(" at character 40
> I'm running v7.4.5.
Put an
"Chris" <[EMAIL PROTECTED]> writes:
> chris=> create index blah on ff_index(substring(icontent, 0, 200));
> ERROR: syntax error at or near "(" at character 40
> I'm running v7.4.5.
Put an extra set of parens around it:
create index blah on ff_index((substring(icontent, 0, 200)));
"subs
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 tho
