Re: How to find persons who like red fruits or crunchy veggies?

From: Neo <neo55592_at_hotmail.com>
Date: 16 Nov 2006 13:34:58 -0800
Message-ID: <1163712898.830930.53680_at_b28g2000cwb.googlegroups.com>


> find pilots that can fly all airplanes

How can I do this in SQL? Below script models the data in dbd, however the query does not work (currently the function named ALL does not exist).

(new 'fly 'verb)

(new 'jet1 'jet)
(new 'jet2 'jet)

(new 'pilot1 'pilot)
(create pilot1 fly jet1)

(new 'pilot2 'pilot)
(create pilot2 fly jet1)
(create pilot2 fly jet2)

(; Find pilots who fly all jets)
(; Does not work currently)
(and (select pilot instance *)

       (select * fly (ALL (select jet instance *)))) Received on Thu Nov 16 2006 - 22:34:58 CET

Original text of this message