[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