RE: Tables with foreign keys to themselves don't maintain Lists ofrelated rows.

[Dave Newton <da...@solaraccess.com>]

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 :)

Dave



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