Re: inserting values into types

hi mike,

sorry for confusion, the test_x is my mistake, its from another type i created which is executing the same code.

my error i get from:

CREATE TYPE qwerty_UDT AS (abc INT);

CREATE TABLE t (col1 qwerty_UDT);

INSERT INTO t (col1) VALUES (qwerty_UDT(123));

is:

ERROR: function 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" <mike(at)fuhr(dot)org>
To: "Andrew Thorley" <andrew(dot)thorley(at)linuxmail(dot)org>
Subject: Re: [SQL] inserting values into types
Date: Wed, 1 Dec 2004 10:53:01 -0700

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

--
______________________________________________
Check out the latest SMS services @ http://www.linuxmail.org
This allows you to send and receive SMS through your mailbox.

Powered by Outblaze