[Babase] ranker again

Susan Alberts alberts at duke.edu
Sat Oct 7 17:21:49 EDT 2006


See below
On Oct 6, 2006, at 2:20 PM, Karl O. Pinc wrote:

> Ok.  I won't make another new table.  But I will add another
> column to RNKTYPES, RNKTYPES.Master.  When there's a master
> ranktype then the rankings in the given type must be consistent
> with the rankings in the master.

It depends on what you mean by consistent. The same relative rankings  
between individuals should obtain, but they might have different rank  
numbers. Thus in ALF, females ranked 3,5,7 might be 1,2,3 in JUF.

> I believe this is eaiser
> than simply hardcoding the rank type values into the triggers
> because if I do that then I have to code in restrictions
> as who can change which RNKTYPES when, when
> rows can be deleted, etc., so that the triggers
> won't do wierd things should RNKTYPES change.  And I'd
> have to document all that too.

Sorry, I don't understand your description of this constraint. Can  
you try again?
>
> Is this ok?  If there's any substantive questions
> it might be best to have a phone call so we can discuss
> things.
>
I am out of town T-F this week but you all could proceed without me.  
Jeanne is here in DUrham and I don't think I really have unique info  
to add on this, so this could happen. Or not, if we don't need it.

Susan

-----------------------------------------------
Susan Alberts, Dept. Biology, Duke University, Durham NC 27708. Phone  
919-660-7272, Fax 919-660-7293. alberts at duke.edu





More information about the Babase mailing list