Thread

Using lower in create index

pierre@desertmoon.com — 1998-11-11T01:20:32Z

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