Re: How to find persons who like red fruits or crunchy veggies?
Date: 15 Nov 2006 14:57:22 -0800
> In your language, can you query:
> How many fruit colors are there? [Yes]
> Which fruit color(s) is/are the most liked? [No]
> How many veggies are there that nobody likes? [No]
Currently dbd's NLI (SQL-type) interface implements very basic functions such as create, select, update and delete (and a few others listed at www.dbfordummies.com/NLI/function.asp).
Even modest functions such as MIN, MAX, etc would need to be implemented by application interfacing to a db via API. See www.dbfordummies.com/example/ex010b.asp which generates a nearest common ancestor report for things in a hierarchy.
Below are the closest queries that dbd can perform via its NLI:
(; Count fruits)
(count (select fruit instance *))
(; Count colors for fruits)
(count (and (select color instance *)
(select (select fruit instance *) color *)))
(; Find veggies somebody likes)
(and (select veggie instance *)
(select (select person instance *) like *)) Received on Wed Nov 15 2006 - 23:57:22 CET