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