Suppose I define a custom collating sequence FOO, and use it on an indexed 
column:

   CREATE TABLE mytable (mykey TEXT PRIMARY KEY COLLATE FOO, ...)

It seems to me that it shouldn't be necessary for SQLite to evaluate FOO's 
comparison function when doing queries on mytable; the collation order should 
be implicit in the mykey column's index.  Is this in fact the case?

Thanks!

Will


--
Will Duquette -- william.h.duque...@jpl.nasa.gov
Athena Development Lead -- Jet Propulsion Laboratory
"It's amazing what you can do with the right tools."

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to