Nice solution! CREATE TABLE edges(parent references nodes, child references nodes check (parent<>child));
seems to be an equivalent but shorter statement. On 20 December 2017 at 07:49, Simon Slavin <slav...@bigfraud.org> wrote: > > > Yes ! > > CREATE TABLE edges( > parent INTEGER references nodes, > child INTEGER references nodes, > CONSTRAINT NotMyOwnGrandpa CHECK (child <> parent) > ); > > You’ll get a failure result code from the INSERT. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users