[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: RFC: Moving menu.ini information into the database

On 6/28/07, Josh Berkus <..hidden..> wrote:

> 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


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.
Ledger-smb-devel mailing list