On 11/18/10 2:16 PM, "Drake Wilson" <dr...@begriffli.ch> wrote:
Quoth "Duquette, William H (316H)" <william.h.duque...@jpl.nasa.gov>, on
2010-11-18 14:08:10 -0800:
> 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?
When doing which queries?
How do you propose to look up a key value in the index without using
the collation function?
I was thinking of queries like
SELECT mykey FROM mytab ORDER BY mykey
But yes, looking up a particular record would have
to use the collation function function, wouldn't it.
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
