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 <[email protected]> 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
