[GENERAL] Creating case insensative Index

[Vince DiCiero]

I am receiving  the following errors on creating an index using lower() on a
varchar field

db1=> create index fieldindexlower on table1(lower(fieldvalue) varchar_ops);
ERROR:  BuildFuncTupleDesc: function 'lower(varchar)' does not exist


Do I need to convert the field to "text" or are there other options ?

Thanks,
Vince


************