Hi Richard, I wasn't aware one could create indices on the results of a function. I've pushed a hack to the darcs repository that makes your example possible: (sql (:create-index :my-index :on :my-table :fields (:lower :my-column))) => "CREATE INDEX my_index ON my_table (lower(my_column))" Best, Marijn