Re: COMMUTATOR doesn't seem to work

"D'Arcy Cain" <darcy@druid.net> writes:
> Maybe I am using it wrong but I get no error message when I use it.  I
> have a type called chkpass (a version is in the additional supplied
> modules) and I create the equality operator like this:

> CREATE OPERATOR = (
>          PROCEDURE = eq,
>          LEFTARG = chkpass,
>          RIGHTARG = text,
>          COMMUTATOR = =,
>          NEGATOR = <>
> );

Did you actually create a "text = chkpass" function and operator?
This declaration merely promises that you will provide one eventually.
The system does not have the ability to make one for you.
        regards, tom lane