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
