Creating case insensative Index - Mailing list pgsql-general

From Vince DiCiero
Subject Creating case insensative Index
Date
Msg-id 000701bf2044$87ad26c0$3600a8c0@home.com
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: mfb@radical-solutions.co.uk (Mike Brickman)
Date:
Subject: Re: [GENERAL] Windows Server?
Next
From: "Tim Joyce"
Date:
Subject: QUERY PLAN: