On 24/07/2009 3:22 AM, Simon Slavin wrote:
> And note that if you have a column which is an integer that
> has doesn't allow duplicates, SQLite will automatically use that
> column as the one it uses for _rowid_, etc.. So define your own
> integer column, feed it whatever integers you want, and you won't
> waste any space.
Documentation reference, please.
How do you account for this:
SQLite version 3.6.14
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table bar(x text, y integer unique);
sqlite> insert into bar values('aaa', 1);
sqlite> insert into bar values('bbb', 42);
sqlite> insert into bar values('ccc', 666);
sqlite> select rowid, * from bar;
1|aaa|1
2|bbb|42
3|ccc|666
sqlite> insert into bar values('ddd', 42);
SQL error: column y is not unique
sqlite>
?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
