"George Barbarosie" <[EMAIL PROTECTED]> writes: > CREATE TYPE composite AS ( > label varchar(20), > data varchar(1000) );
> CREATE TYPE composite2 AS ( > label varchar(20), > data text ); > CREATE CAST (composite as composite2) WITHOUT FUNCTION AS IMPLICIT; The above is invalid --- since values of composite types have their type OID embedded in them, a coercion can't simply be a relabeling. You've used your superuser powers to break the system, as is all too easy with binary casts :-( regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings