Let's say we have nodes and edges tables - sqlite> .sch nodes CREATE TABLE nodes(id integer primary key, description text); sqlite> .sch edges CREATE TABLE edges(parent references nodes, child references nodes);
Can we restrict the edges table so that inserting or updating a row where edges.parent = edges.child is not allowed and ideally would produce an error message? sqlite> insert into nodes select 1, 'node1'; sqlite> insert into nodes select 2, 'node2'; sqlite> insert into edges select 1, 2; sqlite> insert into edges select 1, 1; -- should be an error here _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
