Re: Type Inheritance - Mailing list pgsql-sql

From Tom Lane
Subject Re: Type Inheritance
Date
Msg-id 10119.1101492847@sss.pgh.pa.us
Whole thread Raw
In response to Type Inheritance  ("Andrew Thorley" <andrew.thorley@linuxmail.org>)
List pgsql-sql
"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


pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Querying a list field against another list
Next
From: Jonathan Knopp
Date:
Subject: Way to stop recursion?