[Babase] ranker again
kfenn
kfenn at princeton.edu
Mon Oct 9 08:24:42 EDT 2006
Hi Susan,
I'll go with whatever Leah says. I've worked with ranker exactly once
and have never considered the rules behind it and am only understanding
about 1/4 of these emails. If she thinks it's fine, then I'm sure I can
learn whatever I need to learn, but I really don't know enough about
this to give a real answer. Sorry!
Tabby
Karl O. Pinc wrote:
>
> On 10/06/2006 11:56:07 AM, Susan Alberts wrote:
>> Karl, should you update the rnktypes table with the new types and
>> remove FYM or can Leah/Tabby do this at this point? I think that you
>> need to update the definition queries? I am not sure what these are.
>
> Leah/Tabby can do it, and they can update the queries after
> each conversion run too, although I could do it also if you want me
> to for some reason.
>
> By way of example, here's the old and new RNKTYPES.Query for ALF:
>
> Old:
> SELECT DISTINCT biograph.sname
> FROM biograph, members
> WHERE biograph.sname = members.sname
> AND members.date >= %s
> AND members.date <= %f
> AND members.grp = %g
> AND biograph.sex = "F"
> AND NOT(EMPTY(matured))
> AND matured <= %f
>
> New:
> SELECT DISTINCT biograph.sname
> FROM biograph, members, maturedates
> WHERE biograph.sname = members.sname
> AND members.date >= '%s'
> AND members.date <= '%f'
> AND members.grp = %g
> AND biograph.sex = 'F'
> AND maturedates.sname = biograph.sname
> AND maturedates.matured <= '%f';
>
> (Note that I have gone ahead and put some of the %
> substitutions inside single quotes because I believe
> this makes more sense and is simpler for the ranker
> program to deal with because it won't have to think
> about what datatype things are and whether or not
> it needs to put quotes around things. The final
> design is up to Jun and Dongdong.)
>
> Karl <kop at meme.com>
> Free Software: "You don't pay back, you pay forward."
> -- Robert A. Heinlein
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
--
Tabby Fenn
Research Assistant
Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ 08544
609 258-6898 (Ph)
609 258-2712 (Fx)
More information about the Babase
mailing list