Leandro Fanzone <leandro(at)hasar(dot)com> writes:
[...]
> CREATE INDEX myfield_index ON mytable(LOWER(myfield));
>
> to perform indexed searches on queries like
>
> SELECT myfield FROM mytable
> WHERE myfield LIKE 'something%';
>
By the way: the above query will use the index only if you are using
the C locale :-(
Regards,
Manuel.