[Babase] Finding intergroup interactions

Karl O. Pinc kop at meme.com
Mon Apr 19 10:58:24 EDT 2010


-- Warning condition
-- Interactions should be between individuals in the same supergroup.
SELECT interact.iid, interact.act, interact.date
       , actor.sname, supergroup(actorgrp.gid, interact.date) as 
actorsu\
pergroup
       , actee.sname, supergroup(acteegrp.gid, interact.date) as 
acteesu\
pergroup
       , 'Warning: Interactions should be between individuals in the 
sam\
e supergroup'
  FROM interact, parts AS actor, parts AS actee
       , members AS acteembr, members AS actormbr
       , groups AS acteegrp, groups AS actorgrp
  WHERE actor.iid = interact.iid
        AND actor.role = 'bb_actor'
        AND actormbr.date = interact.date
        AND actormbr.sname = actor.sname
        AND actorgrp.gid = actormbr.grp
        AND actee.iid = interact.iid
        AND actee.role = 'bb_actee'
        AND acteembr.date = interact.date
        AND acteembr.sname = actee.sname
        AND acteegrp.gid = acteembr.grp
        AND supergroup(actorgrp.gid, interact.date)
            != supergroup(acteegrp.gid, interact.date)
  ORDER BY interact.date, interact.act, interact.iid, actor.sname, 
actee\
.sname;


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