hi tom thanks for reply. im trying to provide inheritance for data types (domains), not tables. i will look into the syntax associated with domains as data types does not include an inheritance function (or so i think).
regards andy. ----- Original Message ----- From: "Tom Lane" <[EMAIL PROTECTED]> To: "Andrew Thorley" <[EMAIL PROTECTED]> Subject: Re: [SQL] Type Inheritance Date: Fri, 26 Nov 2004 13:14:07 -0500 > > "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 > -- ______________________________________________ Check out the latest SMS services @ http://www.linuxmail.org This allows you to send and receive SMS through your mailbox. Powered by Outblaze ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
