X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D0CCCD1C9E1 for ; Sat, 13 Mar 2004 17:30:06 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 11514-09 for ; Sat, 13 Mar 2004 13:30:05 -0400 (AST) Received: from guinness.cs.stevens-tech.edu (guinness.cs.stevens-tech.edu [155.246.89.8]) by svr1.postgresql.org (Postfix) with ESMTP id 5488BD1C9B5 for ; Sat, 13 Mar 2004 13:30:04 -0400 (AST) Received: from dab.cs.stevens-tech.edu (dab.cs.stevens-tech.edu [155.246.89.71]) by guinness.cs.stevens-tech.edu (Postfix) with ESMTP id 0F454141643 for ; Sat, 13 Mar 2004 12:29:55 -0500 (EST) Received: by dab.cs.stevens-tech.edu (Postfix, from userid 4405) id 10A9E1CD818; Sat, 13 Mar 2004 12:30:02 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by dab.cs.stevens-tech.edu (Postfix) with ESMTP id 68E281BBC70 for ; Sat, 13 Mar 2004 12:30:02 -0500 (EST) Date: Sat, 13 Mar 2004 12:30:02 -0500 (EST) From: Yasir Malik To: PostgreSQL Subject: Object-relational features Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/153 X-Sequence-Number: 17252 Hello, 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 machine. Thanks, Yasir