Object Relational features in PostgreSQL

From: "Robert Abi Saab" <RSaab(at)ccc(dot)gr>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Object Relational features in PostgreSQL
Date: 2004-01-26 08:01:19
Message-ID: 30E1F01302400C45A5BF9AE40AF96BBC021DB699@gr-moa-exch-01.moa.gr.ccc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi everyone. I just finished a course on PostgreSQL and I found out that
PostgreSQL doesn't provide any object relational features (as claimed in
the official documentation), except table inheritance and very limited
user defined types (I defined a UDT with 2 attributes and couldn't use
it in a table, and the trainer said it must contain 1 attribute at most
so that it can be used (as a column) in tables)

So my question is whether there is (or will be) any support for (any of)
the following:

More flexible user defined types and support for these in tables

Type inheritance

REF and DEREF data types

Nested tables

Polymorphism and more flexible casting of objects (like the TREAT
function, not only the ONLY function)

Typed tables (create table X of type Y)

Object views

User defined functions (encapsulated in the body of a user defined type)

I would be really thankful for any fast reply, because I need to report
to the management whether a migration to PostgreSQL is both efficient
and possible or not.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fred Moyer 2004-01-26 08:26:00 Re: Object Relational features in PostgreSQL
Previous Message Ara Anjargolian 2004-01-26 05:51:07 big integer design question