Re: inserting values into types - Mailing list pgsql-sql

From Andrew Thorley
Subject Re: inserting values into types
Date
Msg-id 20041201215811.476CF23CE8@ws5-3.us4.outblaze.com
Whole thread Raw
In response to inserting values into types  ("Andrew Thorley" <andrew.thorley@linuxmail.org>)
Responses Re: inserting values into types
Re: inserting values into types
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Sandro Joel Eller
Date:
Subject: Query is slower
Next
From: Tom Lane
Date:
Subject: Re: inserting values into types