I admit it's been awhile, but I don't see anything here http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/ that couldn't be done in R:Base
On Thu, Mar 15, 2012 at 10:43 AM, Bill Downall < [email protected]> wrote: > You can do a self join in R:BASE. You can also have an FK that references > a PK in the same table. > > But you are right that there is no way to anticipate how many layers deep > you may need to go, so you have to have a view or a self join for every > possible number of layers. So cursors can reduce the complexity. > > And R:BASE cannot do the kind of updates that are illustrated in the > SQLTeam.com reference. > > Bill > > > > > > On Thu, Mar 15, 2012 at 1:33 PM, Dan Goldberg <[email protected]>wrote: > >> The problem is rbase cannot join tables to itself and does not recurse >> itself.. That is why you have to use nested cursors. >> >> > >
