>> Here, this link should help:
>>
>> Search PostgreSQL - Opera
>> http://www.postgresql.org/search.cgi?q=connectby
>
> Thanks...rtfm I know :)
RTFM? Oh, yeah, that's right -- Read The /FUNNY/ Manual! =D
--
Randolf Richardson - [EMAIL PROTECTED]
Vancouver, British
> As subj says. A simple menu is defined in a table. But how to extract
> it? Heres the deal:
>
> Table menu has these 3 columns: menuidparentmenudesc
>
> Ok this should be easy right? Those menu-rows that has parent=0 is
> "toplevel". And so forth. An example:
>
> 10"Items"
> 2
>> You're in need of the "CONNECT BY" option which is ideal for
>> scenarios such as yours. Unfortunately PostgreSQL doesn't have it
>> yet, but I believe there is a PLSQL script (or something like this)
>> which emulates the CONNECT BY behaviour and it's called "connectby()"
>> or something l
