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

> 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