CREATE INDEX fooi ON foo (lower(f1)) where f1 is varchar rather than text.
Attach a file by drag & drop or click to upload
