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 follow_intervals view will insert rows, using followid.

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

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

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

26 INSERT INTO follow_intervals (

27 followid

28 , time

29 , followtype

30 , page

31 , collector

32 , entrydate

33 , enterer

34 , uploaddate

35 , gcstatus

37 select focal_follows.followid

38 , '9:00'

39 , 'A'

40 , 1

41 , 'JO'

42 , '2005-06-01'

43 , 'JD'

44 , '2005-06-01'

45 , NULL

46 from focal_follows

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

48 and focal_follows.mom = 'MOM'

49 and focal_follows.infant = 'KID'

50 returning *;