Re: object algebra

From: Joe \ <joe_at_bftsi0.UUCP>
Date: Wed, 25 Feb 2004 20:10:32 -0800
Message-ID: <1077770689.407388_at_news-1.nethere.net>


"Marshall Spight" <mspight_at_dnai.com> wrote in message <news:zYd%b.59944$4o.81521_at_attbi_s52>...

> test=> select sum(to_number(object,'99')) from EX76 where object in
> ( select subject from EX76 where relator = 'isa' AND object = 'age');
> sum
> -----
> 35
> (1 row)
>
>
> Please note that I am not advocating building schemata that look like this.
> I'm just pointing out that an existing relational database can handle it.
>
> Compare the length and clarity of the above SQL with Neo's pseudocode.

Neo's silly scheme doesn't scale. What happens if person X is 98 years old and person Y weighs 98 pounds?

--
Joe Foster <mailto:jlfoster%40znet.com>  "Regged" again? <http://www.xenu.net/>
WARNING: I cannot be held responsible for the above        They're   coming  to
because  my cats have  apparently  learned to type.        take me away, ha ha!
Received on Thu Feb 26 2004 - 05:10:32 CET

Original text of this message