Re: inserting values into types

> 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