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 5B88C3A4707 for ; Thu, 25 Nov 2004 21:47:32 +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 38690-07 for ; Thu, 25 Nov 2004 21:47:20 +0000 (GMT) Received: from webmail-outgoing.us4.outblaze.com (webmail-outgoing.us4.outblaze.com [205.158.62.67]) by svr1.postgresql.org (Postfix) with ESMTP id 253763A47C9 for ; Thu, 25 Nov 2004 21:47:21 +0000 (GMT) Received: from wfilter.us4.outblaze.com (wfilter.us4.outblaze.com [205.158.62.180]) by webmail-outgoing.us4.outblaze.com (Postfix) with QMQP id 9A35118001B6 for ; Thu, 25 Nov 2004 21:47:20 +0000 (GMT) X-OB-Received: from unknown (205.158.62.86) by wfilter.us4.outblaze.com; 25 Nov 2004 21:47:20 -0000 Received: by ws5-4.us4.outblaze.com (Postfix, from userid 1001) id 8751D23EE65; Thu, 25 Nov 2004 21:47:20 +0000 (GMT) Content-Type: text/plain; charset="iso-8859-1" Content-Disposition: inline Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 Received: from [80.41.115.76] by ws5-4.us4.outblaze.com with http for andrew.thorley@linuxmail.org; Fri, 26 Nov 2004 05:47:20 +0800 From: "Andrew Thorley" To: "pgsql-sql @ postgresql . org" Date: Fri, 26 Nov 2004 05:47:20 +0800 Subject: Type Inheritance X-Originating-Ip: 80.41.115.76 X-Originating-Server: ws5-4.us4.outblaze.com Message-Id: <20041125214720.8751D23EE65@ws5-4.us4.outblaze.com> 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/259 X-Sequence-Number: 19577 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); any ideas? --=20 ______________________________________________ Check out the latest SMS services @ http://www.linuxmail.org=20 This allows you to send and receive SMS through your mailbox. Powered by Outblaze