On Thu, 25 Oct 2001, Teodor Sigaev wrote:
> Make me right if I mistake.
>
> When we was developing operator @@, I saw that postgres don't use index in
> select if operation has not commutator. But operator with different types in
> argument can't be commutator with itself. So I maked operator ~~ only for
> postgres can use index access for operator @@. There is no any difficulties to
> adding index support for operator ~~. The same things is with contrib/tsearch
> module.
>
> But I think that there is not any other necessity in presence ~~.
So only one of the two needs to go into pg_amop, correct? Then everything
else is fine.
Take care,
Bill