X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CF0CF3A4AC9 for ; Fri, 26 Nov 2004 18:14:14 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26392-08 for ; Fri, 26 Nov 2004 18:14:12 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 8A8D03A4AA1 for ; Fri, 26 Nov 2004 18:14:11 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id iAQIE7ah010120; Fri, 26 Nov 2004 13:14:08 -0500 (EST) To: "Andrew Thorley" Cc: "pgsql-sql @ postgresql . org" Subject: Re: Type Inheritance In-reply-to: <20041125214720.8751D23EE65@ws5-4.us4.outblaze.com> References: <20041125214720.8751D23EE65@ws5-4.us4.outblaze.com> Comments: In-reply-to "Andrew Thorley" message dated "Fri, 26 Nov 2004 05:47:20 +0800" Date: Fri, 26 Nov 2004 13:14:07 -0500 Message-ID: <10119.1101492847@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/266 X-Sequence-Number: 19584 "Andrew Thorley" writes: > Does anyone know how to implement type inheritance in postgresql? in oracle you just use the word UNDER in ur code i.e: > CREATE TYPE test2_UDT UNDER test1_UDT AS (abc INT); If you had said what this *does*, we might be better able to help. But take a look at CREATE DOMAIN, as well as the INHERITS and LIKE options in CREATE TABLE. Some part of that might be close to what you are looking for. regards, tom lane