There's a good Joe Celko article (with some very helpful SQL examples
here:
http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci537290,00.html
Cheaper than the book (which is worth every penny, or so I'm told)
Funny this should come up, as I've been implementing a general purpose
tree manager based on nested sets this week. It's certainly a little
tricky, but it does make certain operations much easier to implement
(in terms of not running a billion queries to see the whole tree).
-Tim
At 07:59 AM 6/28/2001 -0400, you wrote:
>David,
>
>There is a great discussion of these types of trees in Joe Celko's
>SQL for Smarties.
>
>-dhs
>--
>Dean H. Saxe
>[EMAIL PROTECTED]
>http://www.FullFrontalNerdity.com/
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
