3 ms·

Recursive relation within the same table. A single table can solve this problem. Some animal is pet and some are not this is not their class but these are their

Recursive relation within the same table. A single table can solve this problem. Some animal is pet and some are not this is not their class but these are their property.

FatDrunknStupid 7y ago
A pigs ear! https://www.reddit.com/r/SQL/comments/3vxju8/pigs_ear_in_sql/ https://www.reddit.com/r/SQL/comments/3vxju8/pigs_ear_in_sql...
m33k44 7y ago
> Recursive relation within the same table. A single table can solve this problem. How? Which table will recurse?
- pier25 7y ago
  Not parent commenter but a single table is enough. Each row pointing to its parent row.
- chris5745 7y ago
  Also not parent commenter, and not a guru, but I did manage to implement this with an ORM. https://github.com/BitWorks/xbrlstudio/blob/master/BookDatabaseUtility.py https://github.com/BitWorks/xbrlstudio/blob/master/BookDatab...
- deleted 7y ago
  [deleted]