Correction: Prior post had wrong dbd expression for query #4
(accidently copied that for #3).
QUERY 4) Find persons with builds with whom Bob's build has same
relationship as John's build's relationship with Mary's build (without
explicitly referring to that relationship in the query).
(get * build (get (get bob build *)
(get (get john build *) * (get mary build *))
*))
SELECT answer.name AS "Bob's bld same as john & mary"
FROM Sibling.person john
, Sibling.person_build john_bld
, Sibling.person mary
, Sibling.person_build mary_bld
, Sibling.person bob
, Sibling.person_build bob_bld
, Sibling.person answer
, Sibling.person_build answer_bld
WHERE john.name = 'john'
AND mary.name = 'mary'
AND bob.name = 'bob'
AND john_bld.id = john.id
AND mary_bld.id = mary.id
AND bob_bld.id = bob.id
AND relationship(find_verb(john_bld.build, mary_bld.build),
bob_bld.build, answer_bld.build) = 'Y'
AND answer.id = answer_bld.id;
Received on Mon Jan 08 2007 - 00:43:50 CST
