[Babase] Problems with pregnancies
Karl O. Pinc
kop at meme.com
Thu Jun 22 21:47:16 EDT 2006
Hi,
I'm messing about with Cathrine's latest data updates.
(I don't have them in production yet.)
I see that the conceive date and the resume date HEI1 pregnancy
have intervening cycpoints.
Likewise SIS9 has no resume and this is throwing off REPSTATS.
select repstats.sname, repstats.date, repstats.state as rstate,
repstats.dins as rdins, repstats.dr as rdrs, repstats.pid,
cycstats.state as cstate, cycstats.dins as cdins, cycstats.dr as cdr
from repstats, cycstats where repstats.sname = cycstats.sname and
repstats.date = cycstats.date and repstats.state != 'C' order by
repstats.sname, repstats.date;
select pid, parity, conceive, resume, conceive.date as zdate,
resume.date as rdate from pregs left outer join cycpoints as conceive
on (pregs.conceive = conceive.cpid) left outer join cycpoints as resume
on (resume.cpid = pregs.resume), cycles where cycles.sname = 'SIS' and
conceive.cid = cycles.cid order by parity;
Aside from this, I think CYCSTATS is ready to go so I'll go ahead
and copy the new data into production.
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list