On 2 Apr 2014, at 6:38pm, Donald Steele <xln...@sbcglobal.net> wrote:

> So am I misunderstanding how to get what I am after?
> 
> I am using a select statement to produce a list of records “ordered by” the 
> highway column. 
> My understanding was that the select statement would include my collation as 
> part of the order by function.

If you used your function as part of the column definition ...

myColumn TEXT COLLATE myCollation

... then yes, your function will be called.  But it will be called not once for 
a whole list of values but once for every two values that SQLite needs to 
compare.

Sorry, it's possible that I misunderstood your question about 'since I would 
apply it to a column of a table' in your earlier post.

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

Reply via email to