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]
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
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
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
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
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
