Hi,
> You can have indexed column lower_x which will contain lower(x) and do
queries like
> ... where lower_x = lower(?)
Yes. One addition: the column "lower_x" can be a computed column, so you
don't have to update it yourself:
create table test(x varchar, lower_x varchar as lower(x));
insert into test(x) values('Hello');
select * from test;
Regards,
Thomas
On Fri, Apr 17, 2015 at 10:04 AM, Sergi Vladykin <[email protected]
<javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote:
> You can have indexed column lower_x which will contain lower(x) and do
> queries like
>
> ... where lower_x = lower(?)
>
> Sergi
>
>
>
> 2015-04-17 10:24 GMT+03:00 Noel Grandin <[email protected]
> <javascript:_e(%7B%7D,'cvml','[email protected]');>>:
>
>>
>> On 2015-04-16 11:48 PM, Brian Craft wrote:
>>
>>> Is there any way to make use of a case sensitive index when doing a case
>>> insensitive query?
>>>
>>> Not at the moment, no.
>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "H2 Database" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected]
>> <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');>
>> .
>> To post to this group, send email to [email protected]
>> <javascript:_e(%7B%7D,'cvml','[email protected]');>.
>> Visit this group at http://groups.google.com/group/h2-database.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected]
> <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');>
> .
> To post to this group, send email to [email protected]
> <javascript:_e(%7B%7D,'cvml','[email protected]');>.
> Visit this group at http://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
