On 6/28/07, Josh Berkus <[EMAIL PROTECTED]> 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel > ------------------------------------------------------------------------- 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
