On Mon, Jun 9, 2014 at 7:06 AM, David Q. <dav...@lelantos.org> wrote:
> > 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. > Maybe so. The output of pragmas like table_info is unlikely to change. There are over a half-million distinct applications using SQLite, and any kind of change like that would likely break some small fraction of them. The fraction of programs that break might be small, but with so many, there would still be a large amount of breakage. So we carefully avoid doing things that might lead to breakage without a very compelling reason. > > 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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
