Re: [SQL] indexing of hierarchical data

2001-07-06 Thread Dado Feigenblatt
Josh Berkus wrote: Dado,     Yeah, me again.  What can I say?  I'm procrastinating, and list stuff is a great way to do it.  And I prefer design theory issues. project    sequence shot CopFilm1   alley shooting   death of the bad guy CopFilm2   car chase    death of the bad guy Co

Re: [SQL] indexing of hierarchical data

2001-07-06 Thread Josh Berkus
Dado, Yeah, me again. What can I say? I'm procrastinating, and list stuff is a great way to do it. And I prefer design theory issues. project    sequence shot CopFilm1   alley shooting   death of the bad guy CopFilm2   car chase    death of the bad guy CopFilm3   car

[SQL] indexing of hierarchical data

2001-07-06 Thread Dado Feigenblatt
We make cartoons here. But let's say we were working on 3 different Cop movies. Our projects are devided into project, sequence, and shot. project    sequence shot CopFilm1   alley shooting   death of the bad guy CopFilm2   car chase    death of the bad guy CopFilm3   car chase