Skip site navigation (1) Skip section navigation (2)

Re: Type Inheritance

From: "Andrew Thorley" <andrew(dot)thorley(at)linuxmail(dot)org>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-sql (at) postgresql (dot) org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Type Inheritance
Date: 2004-11-27 14:04:55
Message-ID: 20041127140455.1324023EF6B@ws5-4.us4.outblaze.com (view raw or flat)
Thread:
Lists: pgsql-sql
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" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrew Thorley" <andrew(dot)thorley(at)linuxmail(dot)org>
Subject: Re: [SQL] Type Inheritance 
Date: Fri, 26 Nov 2004 13:14:07 -0500

> 
> "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
> 
> ---------------------------(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

pgsql-sql by date

Next:From: Andrew ThorleyDate: 2004-11-27 15:33:30
Subject: Re: Type Inheritance
Previous:From: Konstantin DanilovDate: 2004-11-27 11:11:55
Subject: how many JOINs ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group