From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrew Thorley <andrew.thorley@linuxmail.org>
Cc: pgsql-sql @ postgresql . org <pgsql-sql@postgresql.org>
Subject: Re: Type Inheritance
Date: Fri, 26 Nov 2004 13:14:07 -0500
Message-ID: <10119.1101492847@sss.pgh.pa.us> (raw)
In-Reply-To: <20041125214720.8751D23EE65@ws5-4.us4.outblaze.com>
References: <20041125214720.8751D23EE65@ws5-4.us4.outblaze.com>
"Andrew Thorley" <andrew.thorley@linuxmail.org> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, andrew.thorley@linuxmail.org
Subject: Re: Type Inheritance
In-Reply-To: <10119.1101492847@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox