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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])