Re: SQL, related records (quotes)

Dan Guntermann wrote:
 >...
> But alas, not many implementations allow for assertions of antisymmetry,
> though it could be done with a trigger. This approach would enforce the
> condition that
> for all (child, parent) relationships that are members of hierarchies, there
> does not exist a tuple of (parent, child). It also has the limiting factor
> of disallowing single node hierarchies.

You meant non-symmetry since anti-symmetry says: you can have (child, parent) and (parent, child) at the same time execept parent=child

Just mentioned ;) (I know antisymmetry works here since you said you don't allow reflexive tupels)

Regards
Stefan

 >... Received on Sun Jun 26 2005 - 03:56:02 CDT