Subject Re: long field to index
Author kaczy27
> > The initial tests gave me negative on this. (by the way wouldn't
> > that be useful? it could help browsing the blobs also)
> Yes, I think it's useful.
It's good they're planned for 2.0

> > The other solution is to create another filed that is computed as
> > substring of the first and index this one.
> You cannot index COMPUTED BY fields, as they aren't stored.
> The one thing you can do, is create a second column and create
> triggers to update it. Index that column.
That's exactly what I ended up with.

> With regards,
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL
> Server
> Upscene Productions

Thanks for ansewer,
CUIN Kaczy