[Babase] Re: Quick fix to rnktypes table needed

Jun Yang junyang at gmail.com
Fri Dec 7 14:03:47 EST 2007


One more tweak needed for FYM; see below. Again, I've fixed it in babase,
but not in babase_copy, etc.

FYM
All females and males < 7	

Old:

SELECT DISTINCT biograph.sname
FROM biograph, members
WHERE biograph.sname = members.sname
AND date >= %s
AND date <= %f
AND members.grp = %g
AND (%f - biograph.birth) >= 1
AND (sex = 'F' OR (sex = 'M' AND (%f - biograph.birth)  < 7))

New last line:

AND %f >= biograph.birth + INTERVAL '1 year'
AND (sex = 'F' OR (sex = 'M' AND %f <= biograph.birth + INTERVAL '7 years'))

--- Jun Y.

On Dec 6, 2007 11:12 AM, Jun Yang <junyang at gmail.com> wrote:
> I just spotted a small bug in rnktypes table: For the ADM (Adult Males) entry,
> the query should NOT be terminated by semicolon ';'.
>
> I've already fixed this in babase (by merely removing the semicolon),
> but not in other copies such as babase_copy, babase_test, etc.
> Can somebody please ensure that all copies are properly updated
> (I am not sure what the proper update procedure is)?
>
> Thanks,
>
> --- Jun Y.
>


More information about the Babase mailing list