[postmodern-devel] creating a function based index

Richard KLINDA rklinda at gmail.com
Sat Jan 2 19:14:42 UTC 2010


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 coerced to a string.
|       [Condition of type SIMPLE-TYPE-ERROR]
`----

Thanks in advance, 
Richard




More information about the postmodern-devel mailing list