Re: [sqlite] the Nth 32-bit int in byte array in query
sort by with substr? I hadn't thought of doing that.. Thanks! On Wed, May 15, 2013 at 5:38 AM, E. Timothy Uy wrote: > Scratch that - I realized I could use substr. > > > On Tue, May 14, 2013 at 11:57 PM, E. Timothy Uy 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] the Nth 32-bit int in byte array in query
Scratch that - I realized I could use substr. On Tue, May 14, 2013 at 11:57 PM, E. Timothy Uy 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] the Nth 32-bit int in byte array in query
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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users