Re: [SQL] Tree structure

2000-09-11 Thread Zeljko Trogrlic
Normally it's done with self-relation. You need a table with "ID" and "PARENT_ID". PARENT_ID will contain null for root level and other row's ID for children. One warning: going through such tree could be slow. I don't know is there anything PostgreSQL specific that might help. I know that Oracle

Re: [SQL] Tree structure

2000-09-12 Thread Zeljko Trogrlic
Thanks for your offer, I'll be very interested to see how you did that. I also found very interesting solution at http://www.dbmsmag.com/9603d06.html http://www.dbmsmag.com/9604d06.html http://www.dbmsmag.com/9605d06.html At 11:22 12.9.2000 , kovacsz wrote: >We are using tree structures (and par