[postmodern-devel] creating a function based index

Marijn Haverbeke marijnh at gmail.com
Mon Jan 4 17:26:51 UTC 2010


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




More information about the postmodern-devel mailing list