Josh Berkus wrote: > Chris, > >> Unfortunately, SQL is pretty bad at handling arbitrary-depth menus >> (esp. without WITH RECURSIVE or CONNECT BY). Fortunately, the amount >> of data is likely to be pretty small, so it is not too bad using >> stored procedures. > > See connect_by() in tablefunc. Please don't reinvent the wheel.
Actually, I also have a bunch of code for menu tables powered by ltree. --Josh ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
