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