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 BF1223A5428 for ; Wed, 1 Dec 2004 23:00: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 95392-06 for ; Wed, 1 Dec 2004 23:00:12 +0000 (GMT) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id C89533A53DE for ; Wed, 1 Dec 2004 23:00:11 +0000 (GMT) Received: (qmail 3795 invoked by uid 65534); 1 Dec 2004 23:00:11 -0000 Received: from p5087F73C.dip0.t-ipconnect.de (EHLO hermes.hilbert.loc) (80.135.247.60) by mail.gmx.net (mp026) with SMTP; 02 Dec 2004 00:00:11 +0100 X-Authenticated: #1433807 Received: (from ncq@localhost) by hermes.hilbert.loc (8.11.6/8.11.6/SuSE Linux 0.5) id iB1MhB603095 for pgsql-sql@postgresql.org; Wed, 1 Dec 2004 23:43:11 +0100 Date: Wed, 1 Dec 2004 23:43:11 +0100 From: Karsten Hilbert To: pgsql-sql@postgresql.org Subject: Re: inserting values into types Message-ID: <20041201234311.L622@hermes.hilbert.loc> References: <20041201215811.476CF23CE8@ws5-3.us4.outblaze.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20041201215811.476CF23CE8@ws5-3.us4.outblaze.com> User-Agent: Mutt/1.3.22.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200412/11 X-Sequence-Number: 19631 > CREATE TYPE qwerty_UDT AS (abc INT); > > CREATE TABLE t (col1 qwerty_UDT); > > INSERT INTO t (col1) VALUES (qwerty_UDT(123)); > > 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. Well, doesn't the error message say it ? "function ... does not exist". The question would be why are you doing "qwerty_UDT(123)" in the first place ? It seems you'd want to be casting ? PostgreSQL, in any case, thinks you want to call a function qwerty_UDT(integer) which it can't find. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346