sort by with substr? I hadn't thought of doing that...... Thanks!
On Wed, May 15, 2013 at 5:38 AM, E. Timothy Uy <[email protected]> wrote: > Scratch that - I realized I could use substr. > > > On Tue, May 14, 2013 at 11:57 PM, E. Timothy Uy <[email protected]> wrote: > > > I'm using matchinfo(...,'s') to get the length of the longest subsequence > > of phrase matches from FTS4. I have 4 columns, so I end up with a byte > > array that is 16 bytes long. I would like to extract the value for the > Nth > > column in query and sort by it. I would also be interested in getting the > > Max() value. Is there a way of doing this without writing any additional > > functions? > > > > Thanks, > > Tim > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
