From: | Hannu Krosing <hannu(at)tm(dot)ee> |
---|---|
To: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: OO future |
Date: | 2002-10-30 06:35:09 |
Message-ID: | 1035959709.3268.3.camel@taru.tm.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Vladimir Chukharev | 2002-10-30 06:50:12 | Re: Is regress/report.php in use? |
Previous Message | Bruce Momjian | 2002-10-30 05:04:15 | Re: move 0 behaviour |