[Dev] Representing Tree/hierachical data in a relational database

[Brent Verner]

[2002-06-19 23:33] John Beimler said:
| Looking for some suggestions on storing parent/child relationships in a
| relational database.  I got spoiled with Oracle and the built in support
| for that.  I'd rather not just go with children having a pointer to
| their parent, I know there must be a more efficient method.

see if this helps.
  
  http://www.intelligententerprise.com/001020/celko1_1.shtml

If not, search for that link in the postgresql.org mailing lists 
(maybe pgsql-users) for other interesting comments on this question.

cheeres.
  b

-- 
"Develop your talent, man, and leave the world something. Records are 
really gifts from people. To think that an artist would love you enough
to share his music with anyone is a beautiful thing."  -- Duane Allman