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,
ageint);
Comments? I nothinig found about OO in the current TODO. BTW, myexamples are only small part of possible OO features,
theothersideas are for example define PRIVATE/PUBLIC attributes in compositetypes and methods, "SELECT p.name FROM
personp WHERE p.pay->tax() > 100;" Karel
-- Karel Zak <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/C, PostgreSQL, PHP, WWW, http://docs.linux.cz,
http://mape.jcu.cz
