X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 77BE33A51CA for ; Tue, 30 Nov 2004 23:51:28 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79772-06 for ; Tue, 30 Nov 2004 23:51:19 +0000 (GMT) Received: from webmail-outgoing.us4.outblaze.com (webmail-outgoing.us4.outblaze.com [205.158.62.67]) by svr1.postgresql.org (Postfix) with ESMTP id 2FD5E3A3CC2 for ; Tue, 30 Nov 2004 23:51:20 +0000 (GMT) Received: from wfilter.us4.outblaze.com (wfilter.us4.outblaze.com [205.158.62.180]) by webmail-outgoing.us4.outblaze.com (Postfix) with QMQP id 727E81800280 for ; Tue, 30 Nov 2004 23:51:18 +0000 (GMT) X-OB-Received: from unknown (205.158.62.156) by wfilter.us4.outblaze.com; 30 Nov 2004 23:51:17 -0000 Received: by ws5-7.us4.outblaze.com (Postfix, from userid 1001) id E60912B2B86; Tue, 30 Nov 2004 23:51:17 +0000 (GMT) Content-Type: text/plain; charset="iso-8859-1" Content-Disposition: inline Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 Received: from [80.41.16.45] by ws5-7.us4.outblaze.com with http for andrew.thorley@linuxmail.org; Wed, 01 Dec 2004 07:51:17 +0800 From: "Andrew Thorley" To: pgsql-sql@postgresql.org Date: Wed, 01 Dec 2004 07:51:17 +0800 Subject: inserting values into types X-Originating-Ip: 80.41.16.45 X-Originating-Server: ws5-7.us4.outblaze.com Message-Id: <20041130235117.E60912B2B86@ws5-7.us4.outblaze.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200411/302 X-Sequence-Number: 19620 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 scena= rio, or offer help in any way? ty in advance :) --=20 ______________________________________________ Check out the latest SMS services @ http://www.linuxmail.org=20 This allows you to send and receive SMS through your mailbox. Powered by Outblaze