darcs - gombemi

3 -- This file is part of Gombe-MI.

5 -- Gombe-MI is free software; you can redistribute it and/or modify

6 -- it under the terms of the GNU General Public License as published by

7 -- the Free Software Foundation; either version 3 of the License, or

8 -- (at your option) any later version.

10 -- This program is distributed in the hope that it will be useful,

11 -- but WITHOUT ANY WARRANTY; without even the implied warranty of

12 -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

13 -- GNU General Public License for more details.

15 -- You should have received a copy of the GNU General Public License

16 -- along with Gombe-MI. If not, see <http://www.gnu.org/licenses/>.

18 -- Test that the family_dists view will insert rows, using followid and

19 -- time.

21 -- All data appearing in this work are fictitious. Any resemblance to

22 -- actual data, living or archived, is purely coincidental.

24 -- Karl O. Pinc <kop@meme.com>

27 INSERT INTO family_dists (

28 followid

29 , time

30 , uncertain

31 , distance

32 , d_mom

33 , d_momrole

34 , d_infant

35 , d_infantrole

37 select focal_follows.followid

38 , '9:00'

39 , false

40 , '1'

41 , 'MOM'

42 , 'M'

43 , 'KID'

44 , 'I'

45 from focal_follows

46 where focal_follows.date = '2004-06-01'

47 and focal_follows.mom = 'MOM'

48 and focal_follows.infant = 'KID';