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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
