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: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "pgsql-sql @ postgresql . org" <pgsql-sql@postgresql.org>
Date: Sat, 27 Nov 2004 22:04:55 +0800
Subject: Re: Type Inheritance
Message-Id: <20041127140455.1324023EF6B@ws5-4.us4.outblaze.com>

hi tom thanks for reply.

im trying to provide inheritance for data types (domains), not tables. i wi=
ll look into the syntax associated with domains as data types does not incl=
ude an inheritance function (or so i think).

regards andy.


----- 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
> "Andrew Thorley" <andrew.thorley@linuxmail.org> writes:
> > Does anyone know how to implement type inheritance in postgresql? in or=
acle 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 your
>       joining column's datatypes do not match
>=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