From: Andrew Thorley <andrew.thorley@linuxmail.org>
To: pgsql-sql@postgresql.org
Subject: inserting values into types
Date: Wed, 01 Dec 2004 07:51:17 +0800
Message-ID: <20041130235117.E60912B2B86@ws5-7.us4.outblaze.com> (raw)
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
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
which is quite confusing, does anyone have any ideas or exp with this scenario, or offer help in any way?
ty in advance :)
--
______________________________________________
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
Subject: Re: inserting values into types
In-Reply-To: <20041130235117.E60912B2B86@ws5-7.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