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

Neo wrote:
> The following dbd query finds persons who like either red fruits or
> crunchy veggies:
>
> (and (select person instance *)
> (select * like (or (and (select fruit instance *)
> (select * color red))
> (and (select veggie instance *)
> (select * texture crunchy))
> )
> )
> )
>
> What RMDB schema and SQL query will find the equivalent? Should I start
> with T_Person, T_Fruit, T_Veggie, T_PLikeF, T_PLikeV ?

I like tomatoes. Imagine a world without them. No ketchup. No pizza base. Are they fruit or veges? They're not especially crunchy though anyway. What about red capsicums? Are they crunchy veges or fruit? Received on Thu Nov 16 2006 - 04:50:15 CET