Am 02.03.2012 10:44, schrieb Christoph P.U. Kukulies:
When defining a column TEXT PRIMARY KEY (is that possible on TEXT?),
yes
would this imply uniqueness?
yes
Or would I have to write something like TEXT PRIMARY KEY UNIQUE ?
no and that doesn't make sense I'd say
[...]
simply try (untested)
CREATE TABLE test(
a TEXT INTEGER PRIMARY KEY
);
INSERT INTO test(a) VALUES('1');
INSERT INTO test(a) VALUES('1');
oliver
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
