On Tue, Jan 10, 2012 at 12:30 PM, Marco Bambini <ma...@sqlabs.net> wrote:
> From the PRAGMA index_info documentation: > This pragma returns one row each column in the named index. The first > column of the result is the rank of the column within the index. The second > column of the result is the rank of the column within the table. The third > column of output is the name of the column being indexed. > > I am particularly interested in the rank fields … what does rank really > means here? > Is there a lower/upper bound to this rank value? > Rank means the position in the table or index. The first column of the table is 0. The second column of the table is 1. The third column is 2, and so forth. Similarly for the index. > > Thanks a lot. > -- > Marco Bambini > http://www.sqlabs.com > http://twitter.com/sqlabs > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
