[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