db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dave Newton <d...@solaraccess.com>
Subject RE: Tables with foreign keys to themselves don't maintain Lists ofrelated rows.
Date Tue, 23 Sep 2003 21:07:11 GMT
On Tue, 2003-09-23 at 17:01, Gary Baker wrote:
> No, that's not true, the semantics may seem confusing, but it is
> perfectly legal to have a self-referential foreign key (at least in the
> databases with which I'm familiar DB2, SQLServer, Oracle).  This is
> really the only way to build a proper tree structure out of your data.

Oh. I guess it's just a matter of semantics then. I haven't done any
trees using Torque, although I've done them "by hand" with MySQL, with
index references to the same table.

Thanks for the clarification :)


To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message