On Wed, 29 Apr 2015 21:53:09 +0100, Lester Caine lester@... [firebird-support] <firebird-support@yahoogroups.com> wrote:

>
> The calculated fields don't actually exist in the database. They are
> created when a record is accessed. What would be better in your case is
> to create the calculated field in a trigger and add it to the record.
> That way the data can be indexed and searched like any other field.
>

Yes, but CONTAINING would not use index anyway. And it is always possible
tu use computed indexes for computed fields.

--
Virgo Pärna
virgo.parna@...