[Babase] Finding intergroup interactions

Niki Learn nlearn at princeton.edu
Mon Apr 19 11:08:41 EDT 2010


Um, this is what it returns...  I'll adapt my query to females.

SELECT interact.iid, interact.act, interact.date
       , actor.sname, supergroup(actorgrp.gid, interact.date) as
actorsupergroup
       , actee.sname, supergroup(acteegrp.gid, interact.date) as
acteesupergroup
       , 'Warning: Interactions should be between individuals in the same
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;

0 row(s)

Total runtime: 749.483 ms

SQL executed.


-----Original Message-----
From: babase-bounces at eeblistserv.Princeton.EDU
[mailto:babase-bounces at eeblistserv.Princeton.EDU] On Behalf Of Karl O. Pinc
Sent: Monday, April 19, 2010 10:58 AM
To: babase at eeblistserv.Princeton.EDU
Subject: [Babase] Finding intergroup interactions


-- 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


_______________________________________________
Babase mailing list
Babase at www.eco.princeton.edu
http://www.eco.princeton.edu/mailman/listinfo/babase



More information about the Babase mailing list