Thread: Creating case insensative Index

Creating case insensative Index

From
"Vince DiCiero"
Date:
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