Re: COMMUTATOR doesn't seem to work

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "D'Arcy Cain" <darcy(at)druid(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: COMMUTATOR doesn't seem to work
Date: 2012-06-22 04:22:07
Message-ID: 229.1340338927@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"D'Arcy Cain" <darcy(at)druid(dot)net> writes:
> On 12-06-21 12:18 PM, Tom Lane wrote:
>> 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.

> I guess I am missing the point of COMMUTATOR then. The docs say "When
> you are defining a self-commutative operator, you just do it." It
> seems you need to do more than "just do it.

Um, an operator with different types on left and right cannot be its own
commutator.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message D'Arcy Cain 2012-06-22 04:32:35 Re: COMMUTATOR doesn't seem to work
Previous Message Kyotaro HORIGUCHI 2012-06-22 04:03:16 Re: Skip checkpoint on promoting from streaming replication