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

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

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