On 4/5/2012 12:33 PM, Pete wrote:
Thank you Igor and Simon, I think I understand this now. On reading the docs more closely, it looks like the scond test case (NOT NULL with a DEFAULT) could be solved by using INSERT OR REPLACE.
I don't see how.
I'm wondering if there might be a way to solve the first test case by using a trigger?
Possibly. I don't quite understand the nature of the problem, nor what would constitute a solution.
Would something like this help? insert into t2 SELECT Col1, coalesce(Col2, 'abc') from t1; -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users