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
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