Content-Type: text/plain; charset="iso-8859-1"
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
From: "Andrew Thorley" <andrew.thorley@linuxmail.org>
To: "Andrew Thorley" <andrew.thorley@linuxmail.org>,
	"Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "pgsql-sql @ postgresql . org" <pgsql-sql@postgresql.org>
Date: Sat, 27 Nov 2004 23:33:30 +0800
Subject: Re: Type Inheritance
Message-Id: <20041127153330.2568F416118@ws5-2.us4.outblaze.com>

"If you had said what this *does*, we might be better able to help"

basically i have a series of types (or data types), of which one is the roo=
t and each of the other types appear under the root as in generalisation/sp=
ecialisation style, inheriting the above types attributes etc. this is what=
 im trying to achieve, although at present, to no avail :(


----- Original Message -----
From: "Andrew Thorley" <andrew.thorley@linuxmail.org>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Subject: Re: [SQL] Type Inheritance
Date: Sat, 27 Nov 2004 22:04:55 +0800

>=20
> hi tom thanks for reply.
>=20
> 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 in=
clude an inheritance function (or so i think).
>=20
> regards andy.
>=20
>=20
> ----- Original Message -----
> From: "Tom Lane" <tgl@sss.pgh.pa.us>
> To: "Andrew Thorley" <andrew.thorley@linuxmail.org>
> Subject: Re: [SQL] Type Inheritance=20
> Date: Fri, 26 Nov 2004 13:14:07 -0500
>=20
> >=20
> > "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);
> >=20
> > If you had said what this *does*, we might be better able to help.
> >=20
> > 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.
> >=20
> > 			regards, tom lane
> >=20
> > ---------------------------(end of broadcast)---------------------------
> > TIP 9: the planner will ignore your desire to choose an index scan if y=
our
> >       joining column's datatypes do not match
> >=20
>=20
> --=20
> ______________________________________________
> Check out the latest SMS services @ http://www.linuxmail.org=20
> This allows you to send and receive SMS through your mailbox.
>=20
>=20
> Powered by Outblaze
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>=20

--=20
______________________________________________
Check out the latest SMS services @ http://www.linuxmail.org=20
This allows you to send and receive SMS through your mailbox.


Powered by Outblaze