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