On 11/18/10 8:57 PM, "Dan Kennedy" wrote:
On 11/19/2010 05:22 AM, Duquette, William H (316H) wrote:
> On 11/18/10 2:16 PM, "Drake Wilson" wrote:
>
> Quoth "Duquette, William H (316H)", on
> 2010-11-18 14:08:10 -0800:
>> It seems to me that it shouldn't be necessary for SQLite to evaluate
>> FOO
On 11/19/2010 05:22 AM, Duquette, William H (316H) wrote:
> On 11/18/10 2:16 PM, "Drake Wilson" wrote:
>
> Quoth "Duquette, William H (316H)", 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
On 11/18/10 2:16 PM, "Drake Wilson" wrote:
Quoth "Duquette, William H (316H)" , 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 co
Quoth "Duquette, William H (316H)" , 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?
W
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
5 matches
Mail list logo