Gleb Kouzmenko <[EMAIL PROTECTED]> writes:
> I quoted two EXPLAINs below again: WHERE i<<'IP' and WHERE 'IP'>>i is
> logically equivalent, but are planned differently

If you'd like to fix that, see match_special_index_operator() and
expand_indexqual_conditions() in src/backend/optimizer/path/indxpath.c.
I can't get very excited about it myself.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Reply via email to