On 20 Oct 2011, at 9:15pm, Peter Aronson wrote: > What I have done at the moment is added a fourth column named "readonly" to > pragma database_list (it gets the value for this column from a function I > added > called sqlite3BtreeIsreadonly(), which in turn > is a wrapper around sqlite3PagerIsreadonly()),
> and a fourth column named "desc" > to pragma index_info (it gets the value for this column from > pIdx->aSortOrder[i]). Not so sure about the first of these, but your extension to 'PRAGMA index_info' would appear to be an obviously useful one. From my point of view the column should always contain 'ASC' or 'DESC' but other people on this list may have other opinions. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
