Re: inserting values into types

On Wed, Dec 01, 2004 at 06:07:34PM +0800, Andrew Thorley wrote:

> > Did you type the SQL statements and/or error messages instead
> > of cutting and pasting?
>
> yes i C&P'ed the SQL code & error code.

But did you copy the error message associated with the SQL code you
copied, or did you copy some other error message? I ask because
the function name in the error doesn't match the function name in
the INSERT statement. Here's what I get when I execute the statements
in your message:

test=> CREATE TYPE qwerty_UDT AS (abc INT);
CREATE TYPE
test=> CREATE TABLE t (col1 qwerty_UDT);
CREATE TABLE
test=> INSERT INTO t (col1) Values (qwerty_UDT(123));
ERROR: function qwerty_udt(integer) does not exist

You said the error you got was:

ERROR: function test_x(integer) does not exist

The error is the same but the detail differs: your error refers
to test_x(integer) instead of qwerty_udt(integer). So where is
test_x coming from?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/