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