Using lower in create index
pierre@desertmoon.com
From: pierre <pierre@desertmoon.com>
To: <pgsql-sql@postgreSQL.org>
Date: 1998-11-11T01:20:32Z
Lists: pgsql-sql
I've been trying to create an index on a varchar field and I've tried using the following to create the index. create table subject ( name varchar(85) ); create index subject_idx on subject using btree(lower(name) text_ops); Gives me an error that the function lower(varchar) doesn't exist. I've tried placing a text(name) to force the arg to a text value, but get a syntax error. Anyone have Ideas on creating a lowercase index on a field that isn't always lowercase? Pierre