Re: OO future

Here is an O'Reilly article talking about Oracle's OO capabilities:
http://www.oreillynet.com/pub/a/network/2002/10/29/Feuerstein.html

---------------------------------------------------------------------------

Hannu Krosing wrote:
> Karel Zak kirjutas K, 30.10.2002 kell 10:08:
> > 
> >  Hi, 
> > 
> >  I read a presentation about Object-Oriented features in relation DBs.
> >  The nice are UDT (user defined type):
> > 
> >  CREATE TABLE person (
> >     name varchar(32),
> >     address ROW( street varchar(32),
> >                  town   varchar(32)),
> >     age int
> >  );
> > 
> >  INSERT INTO person VALUES ('Bill', ('Somestreet', 'Sometown'), 33);
> > 
> >  SELECT name, address.town FROM person;
> > 
> > 
> >  We have composite types in PostgreSQL and I think we can use it for this:
> > 
> >  CREATE TYPE addr AS (street varchar(32), town varchar(32));
> >  CREATE TABLE person (
> >     name varchar(32),
> >     address addr,
> >     age int
> >  );
> >  
> > 
> >  Comments? I nothinig found about OO in the current TODO.
> 
> I'm writing a small proposal for evoving inheritance and other OO
> features in 7.4 and beyond. Will post once 7.3 is out.
> 
> > BTW, my
> >  examples are only small part of possible OO features, the others
> >  ideas are for example define PRIVATE/PUBLIC attributes in composite
> >  types
> 
> At least the "Third Manifesto" by Date et.al. claims that PRIVATE/PUBLIC
> is better left to standard access control mechanisms (GRANT/REVOKE). 
> 
> I agree to that.
> 
> > and methods, "SELECT p.name FROM person p WHERE p.pay->tax() > 100;"
> 
> The methods will probably have problems with syntax clashes with
> existing stuff.
> 
> --------------
> Hannu
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073