Re: Databases as objects

> Without even getting into a good data language but sticking with SQL,
> speculate on the OO equivalent of the following ad hoc program:
>
> INSERT INTO catalog(title, author)
> SELECT library.title AS title, ...

Below is an approx equivalent based on what I could understand of the SQL. (; Following add book3 in catalog since

   its pub_date is between 19990705 and 20030105    and its author or co_author is a member of britNatBio    and it is an item of libraryOfCongress    and it is not on the blackList)
(set catalog

     item
     (!= (and (get book instance *)
              (get * pub_date (<= (>= (get date instance *)
                                                 19990705)
                                           20030105))
              (get * (or author co_author) (get britNatBio member *))
              (get libraryOfCongress item *)
         )
         (get blackList item *)
     )