From: Andrew Thorley <andrew.thorley@linuxmail.org>
To: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: inserting values into types
Date: Thu, 02 Dec 2004 05:58:11 +0800
Message-ID: <20041201215811.476CF23CE8@ws5-3.us4.outblaze.com> (raw)
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@fuhr.org>
To: "Andrew Thorley" <andrew.thorley@linuxmail.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: andrew.thorley@linuxmail.org, mike@fuhr.org
Subject: Re: inserting values into types
In-Reply-To: <20041201215811.476CF23CE8@ws5-3.us4.outblaze.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox