"Michael Enke" <[EMAIL PROTECTED]> writes: > if I have defined my own data type/operators, > in a check constraint this type is used > instead of ::text.
It looks to me like you must have defined an operator =(varchar,testchar) --- the only way a user-defined type would win over text is to have an exact match. This is not a good idea. Just define =(text,testchar) and leave it to the implicit coercion code to handle varchar. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq