Re: nested sets

2004-07-26 Thread Aman Raheja
Hi Though I would like to look up a way to implement what you want in MySQL, one thing was indicative and I wanted to point out. If, say there was a way, you could remove the c and d rights from subsequent users by removing it from User2, I think you are talking about some kind of history retentio

RE: nested sets vs. key path method

2001-02-13 Thread Jon Haworth
ll [mailto:[EMAIL PROTECTED]] Sent: 13 February 2001 11:13 To: [EMAIL PROTECTED] Subject: Re: nested sets vs. key path method >Hello, >at the time I try to figure out what's the best way >to get a kind of parent/child - hierarchy with unlimited >subchild. >My special attention is

Re: nested sets vs. key path method

2001-02-13 Thread Bob Hall
>Hello, >at the time I try to figure out what's the best way >to get a kind of parent/child - hierarchy with unlimited >subchild. >My special attention is situated on really fast SELECT statements. > >Actually I'm using nested sets like: > >CREATE TABLE Personnel >(emp CHAR(10) PRIMARY KEY, >salar