>>Wait a second, how can you do that? Doesn't that violate >>pg_amop_opc_strategy_index ? >> > > It sure does, but running the script shows that the second insert > doesn't try to insert any rows. There's no entry in the temp table > for ~~ because its left and right operands are not the types the > SELECT/INTO is looking for. > > This is evidently a bug in the script. Oleg? >
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 ~~. -- Teodor Sigaev [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html