Skip site navigation (1) Skip section navigation (2)

Re: inserting values into types

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: inserting values into types
Date: 2004-12-01 22:43:11
Message-ID: 20041201234311.L622@hermes.hilbert.loc (view raw or flat)
Thread:
Lists: pgsql-sql
> 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

In response to

Responses

pgsql-sql by date

Next:From: Christopher BrowneDate: 2004-12-01 22:46:45
Subject: Re: Found Large Files.. what objects are they?
Previous:From: Stephan SzaboDate: 2004-12-01 22:23:12
Subject: Re: Query is slower

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group