Christophe Danker <sqli...@christophe.danker.name> wrote:
> sqlite> create table test("ID" INTEGER NOT NULL, "a" VARCHAR(100), "b"
> VARCHAR(100), PRIMARY KEY("ID","b"));
>
> Also: couldn't that bug be resolved for multi-column primary key situations
> if only one column is of type "INTEGER" (vs "VARCHAR" or even "INT")?
If you want ID to be auto-incremented, then it will always be unique on its
own. Why then do you want a compound primary key? Just declare
ID integer primary key
and be done with it.
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
