> D. Richard Hipp: > No. For a multi-column primary key, the columns that are part of the > primary key are numbered 1, 2, 3, 4, etc, according to which column they > are in the primary key. > For single-column primary keys, they value will always be 1, yes.
You're talking about a different thing, aren't you? It seems you are talking about the 6th column in the result set (column index 5), the "pk" column. I was just wondering whether I could rely on the "name" column being the 2nd column (index 1) and - let's add to this - the "type" column being the 3rd column (index 2). If so can you document it as such once and for all? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users