Subject | Re: [firebird-support] SELECT UPPER(MY_FIELD) -> DON'T USE INDEX |
---|---|
Author | Thomas Woinke |
Post date | 2008-04-22T15:27:04Z |
Hi Sergio,
On Tue, Apr 22, 2008 at 5:20 PM, Sergio H. Gonzalez
<shg_sistemas@...> wrote:
shadow column as described here:
http://www.destructor.de/firebird/caseinsensitivesearch.htm
/thomas
On Tue, Apr 22, 2008 at 5:20 PM, Sergio H. Gonzalez
<shg_sistemas@...> wrote:
> Hi Martijn! Thanks for the answer!you could use shadow columns filled by triggers and then search the
>
> So with FB1.5 it's imposible to use an index for that? It's ok to do the
> query anyway? How did you do it with 1.5?
shadow column as described here:
http://www.destructor.de/firebird/caseinsensitivesearch.htm
/thomas