"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

Reply via email to