db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gary Baker" <gary.ba...@movielink.com>
Subject RE: Tables with foreign keys to themselves don't maintain Listsofrelated rows.
Date Tue, 23 Sep 2003 21:11:17 GMT
I guess you could call it a "Parent Key"...

Either way, my question still stands...

-----Original Message-----
From: Dave Newton [mailto:dave@solaraccess.com] 
Sent: Tuesday, September 23, 2003 2:07 PM
To: Apache Torque Users List
Subject: RE: Tables with foreign keys to themselves don't maintain
Listsofrelated rows.


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


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


Mime
View raw message