| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: object algebra
"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 Wed Feb 25 2004 - 22:10:32 CST
![]() |
![]() |