Skip site navigation (1) Skip section navigation (2)

Object-relational features

From: Yasir Malik <ymalik(at)cs(dot)stevens-tech(dot)edu>
To: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Object-relational features
Date: 2004-03-13 17:30:02
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
For my object-relational database class I decided to use PostgreSQL
because it is my favorite database and it calls it self a ORDBMS.  Little
did I know that it supports supports very little OR features.  For
example, using "create type as" is totally worthless because you can't use
it as a field type in a table; you can't compose in another "create type
as"; and you can't inherit another composite type.  The only way to create
a true type is to use "create type" and write C code as a shared object,
so I'm basically doing everything C, which is not something I want to do.
I've searched the mailing lists and have found little said about the OR
features.  Am I missing something here?  Does PostgreSQL support OR
features similar to Oracle 9i (which is what I'm forced to use).  I really
do not want to use Oracle because I have to switch over to my Windows
partition, and Oracle takes about 100 MB of virtual memory on my 256 MB


pgsql-sql by date

Next:From: RamanDate: 2004-03-15 10:37:16
Subject: Invalid Characters
Previous:From: William Anthony LimDate: 2004-03-13 02:47:37
Subject: function returning resultset

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group