On 27 Oct 2014, at 9:11am, Tristan Van Berkom <tris...@upstairslabs.com> wrote:
> This seems to me to be an elegant solution, but I'd be curious to > know if it would be considered badly designed for some reason, and > would be interested to know what kind of alternatives people would > propose. A foreign key which points to the same table had not occurred to me, outside of abstract mathematical exercises. I think you've come up with an acceptable example of why I felt reluctant to condemn the practise. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users