| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Andrew Thorley" <andrew(dot)thorley(at)linuxmail(dot)org> |
| Cc: | "pgsql-sql (at) postgresql (dot) org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Type Inheritance |
| Date: | 2004-11-26 18:14:07 |
| Message-ID: | 10119.1101492847@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
"Andrew Thorley" <andrew(dot)thorley(at)linuxmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Knopp | 2004-11-26 21:03:38 | Way to stop recursion? |
| Previous Message | Bruno Wolff III | 2004-11-26 15:56:49 | Re: Querying a list field against another list |