Re: Modelling hierarchy in the relational database

From: Todd Gillespie <toddg_at_linux128.ma.utexas.edu>
Date: 18 Aug 2001 02:19:16 GMT
Message-ID: <9lkjb4$bvs$1@geraldo.cc.utexas.edu>

In comp.databases.theory Steve Long <slong3_at_mediaone.net> wrote:
: if you are using Oracle, yes. oracle has provided a non-standard solution.
: look up the "connect by" clause. it supports hierarchical traversal.
: however, if you are using a platform other than oracle, you may have to use
: some other method or function. you can always use procedural code to do a
: traversal. it just depends on how portable the SQL needs to be.

DB2, as I understand it, has tree functions under a different name. SQL3 apparently has them under a totally different name and operation. Received on Fri Aug 17 2001 - 21:19:16 CDT