I've never used it, but my understanding is the tree_sortkey
is the "connect by" (and more).
In the Forums packge, I think OpenForce decided to use the (more
powerful, more general?) tree_sortkey style (originally invented for
OpenACS on PostgreSQL) for both Postgres and Oracle, rather
than using connecty by on Oracle. At least, I think I vaguely recall
someone (Don?) saying that on the BBoards here.