"Andrew Thorley" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
