On 6/28/07, Josh Berkus <..hidden..> 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.
I think this is one dependency we will find we cannot live without. Connectby() is going to be very helpful for a lot of other uses. THanks for the pointer. Chris Travers
--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 ..hidden.. https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel