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,
Hello, is there syntax available for creating function based indexes?
How can I write this in s-sql?
,
| CREATE INDEX my_index ON my_table (LOWER(my_column))
`
I tried
,
| (sql (:create-index :my-index :on :my-table :fields (:lower :my-column)))
|
| => (:LOWER :TERM) cannot be coer
