[Babase] Dates of the "gaps"
Karl O. Pinc
kop at meme.com
Tue Jun 13 15:25:07 EDT 2006
Hi,
Here's the dates I'm putting gaps in (the comments in my programs).
-- Start with all the females.
--
-- babase=> select matgrp, groups.name, min(date), max(date) from
biograph,
cycles, cycpoints, groups where biograph.sname = cycles.sname and
cycles.cid = cycpoints.cid and groups.gid = biograph.matgrp group by
biograph.matgrp, groups.name;
-- matgrp | name | min | max
-- --------+----------+------------+------------
-- 1.00 | Alto's | 1971-07-09 | 2005-05-29
-- 1.10 | Nyayo's | 1993-01-22 | 2005-06-29
-- 1.20 | Dotty's | 1993-08-21 | 2005-06-25
-- 1.21 | Omo's | 2005-04-06 | 2005-04-28
-- 1.22 | Viola's | 2004-04-28 | 2005-06-26
-- 2.00 | Hook's | 1978-06-01 | 2005-06-16
-- 2.10 | Linda's | 2000-11-06 | 2005-06-18
-- 2.20 | Weaver's | 2000-01-07 | 2005-06-26
-- 3.00 | Lodge | 1984-02-05 | 1997-09-12
--
-- Altos start July 1, 1971.
--
-- Anyone in Altos, Dotty's, or Nyayo's from Jan 1, 1990 through
-- Dec 31, 1995, inclusive, only gets observations that cover the
-- cycles for these periods.
--
--
--
-- Proton's after Dec 31, 1990 only gets observed during cycles.
--
--
-- Hooks has observations before this.
--
-- Begin date HOOKS (2.00) 01 Feb 1981
-- End date HOOKS (2.00) 28 Feb 1995
--
-- Begin date LINDAS (2.10) 01 Mar 1995
--
-- Begin date WEAVERS (2.20) 01 Mar 1995
--
-- Begin Lodge (3.0)1 Jan 1985
-- End Lodge 31 Dec 1995
--
-- Joy (3.1) and Nzige (3.2):
-- Begin 1 Jan 1996
-- End 31 Dec 1996
--
-- So, Hooks before start date and Altos in the gap.
-- Otherwise everything is observed.
-- So, our job is to make gaps for these periods.
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