> 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