[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