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_at_geraldo.cc.utexas.edu>
Date: 18 Aug 2001 02:19:16 GMT
Message-ID: <9lkjb4$bvs$1_at_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 Sat Aug 18 2001 - 04:19:16 CEST