On 10 Oct 2009, at 9:27am, Hajime MATSUMOTO wrote: > i used to use "CREATE INDEX" with "ON CONFLICT". > i am sure it was able to do on sqlite 2.x.x. > but i tryed on sqlite3 it dose not work.
You can use 'ON CONFLICT' in either of CREATE TABLE ALTER TABLE ADD COLUMN ... UNIQUE but not when defining an INDEX after you've defined the columns it depends on. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
