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);
any ideas?
--
__
Check out the latest SMS services @ http://www.linuxmail.org
hi can anyone inform me where to get the postgreSQL complex.sql & complex.c
tutorials from, cos i have no idea.
in the 7.4.2-A4 doc it says:
The examples in this section can be found in complex.sql and complex.c in the
src/tutorial
directory of the source distribution. See the README file in th
t; <[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 postg
is is what im trying to achieve, although at present, to no avail :(
- Original Message -----
From: "Andrew Thorley" <[EMAIL PROTECTED]>
To: "Tom Lane" <[EMAIL PROTECTED]>
Subject: Re: [SQL] Type Inheritance
Date: Sat, 27 Nov 2004 22:04:55 +0800
>
> hi
Hi,
ive generated a user defined type: CREATE TYPE qwerty_UDT AS (abc INT);
& table as: CREATE TABLE t (col1 qwerty_UDT);
my prob is that when i try to insert into the type i.e: INSERT INTO t (col1)
Values (qwerty_UDT(123));
i get the error:
ERROR: function test_x(integer) does not exist
HIN
qwerty_udt(integer) does not exist
HINT: No function matches the given name and argument types. You may need to
add explicit type casts.
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Andrew Thorley" <[EMAIL PROTECTED]>
Subject: Re: [SQL]
