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

From: Ed Prochak <edprochak_at_gmail.com>
Date: 16 Nov 2006 07:27:25 -0800
Message-ID: <1163690845.666886.303200_at_h48g2000cwc.googlegroups.com>


Tonkuma wrote:
> 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 ?
> For what dbd schema did you isuued this query? Would you show me exact
> definition of dbd schema?

Please don't encourage Neo. He has an experimental system he created himself. It is non-relational and "nonredundant" in the extreme. (e.g., he attempts to store the word red only once, whether it is used as the color of fruit to someones nickname or a terrorist status).

Do a google search in this group is you feel like browsing nonsense.   Ed

Beware, there be trolls around here. Received on Thu Nov 16 2006 - 16:27:25 CET

Original text of this message